שאלות ותשובות - Wet General Frequently Asked Questions - Wet General Вопросы и Ответы - Wet General أسئلة وأجوبة - Wet General

		.. (לתיקייה המכילה)

Where can we find the PostgreSQL documentations?
Follow the attached link.
קישור: Link: Ссылка: وصلة:	http://www.postgresql.org/docs/7.1/static/postgres.html

I tried to compare between dates, for example select ... from ... where checkin = 2001-01-02

Date should be enclosed with apostrophes. checkin = '2001-01-02'

What is Bus Error? How can we solve it?

The bus error notification indicates anomalous condition on the processor's bus. It is usually due to invalid address alignment, accessing a physical address that does not correspond to any device, or some other device-specific hardware error. Inorder to solve it: try to find duplicate calls for PQclear, insufficient memory allocation (too small buffers) and such.

How can we eliminate "multi lines" warning messages?

Break the strings, using qoutes, according to screen lines. Example: sprintf(cmd,"SELECT XXX FROM " /*<---!*/ "Table1,Table2 WHERE " /*<---!*/ "P1=100 AND ..");

When I delete a record from the DB, how can I know if it realy deleted it or just that the query succeed but didn't delete the record?

Use: char * PQcmdTuples(const PGresult *res); PQcmdTuples Returns the number of rows affected by the SQL command.