sqlbox postgresql bug

Klaus Darilion <[email protected]> Mon, 13 Dec 2004 16:13:49 +0100

Newsgroups	gmane.comp.mobile.kannel.devel
Message-ID	<[email protected]>

Hi Rene!

I found another bug in sqlbox_pgsql.c. Again, the problem is due to 
diffent SQL syntax for pgsql and mysql. In function

Msg *pgsql_fetch_msg()

the select query "SELECT ... FROM %S LIMIT 0,1"

must be changed to

the select query "SELECT ... FROM %S LIMIT 1"


regards,
klaus


PS: pgsql syntax for "LIMIT" is at:
http://www.postgresql.org/docs/7.2/static/queries-limit.html