Re: sqlbox postgresql bug

Thanks... I will change this in the next version.

Rene Kluwen
Chimit

----- Original Message ----- 
From: "Klaus Darilion" <[email protected]>
To: <[email protected]>
Cc: <[email protected]>
Sent: Monday, December 13, 2004 4:13 PM
Subject: sqlbox postgresql bug


> 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
> 
> 
> 
>