Hi Simon,
thanks for the solution.
elpidio
Simon Lebrun wrote:
Hello all,
I haved a error in system with Postgresql 8.03 in linux Fedora C3.
Invalid argument in syntax for select into Postgresql Description When
your try list all Departaments, the system not return any row, because
the syntax into select in Class_departament is invalid, use '' for
null, Postgresql not support this, in Postgresql use "NULL" Additional
Information Ejem. select * from care_departaments where is_active = ''
or is_active = '0', is invalit for Postegresql
The correct is select * from care_departaments where is_active = null
or is_active = '0'
Simón Lebrún
Director
Set Up Solutions C.A.
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
www.setupsolutions.com <http://www.setupsolutions.com>
(58 212) 961.4259
(58 412) 610.0679
-------------------------------------------------------
This SF.Net email is sponsored by Yahoo.
Introducing Yahoo! Search Developer Network - Create apps using Yahoo!
Search APIs Find out how you can build Yahoo! directly into your own
Applications - visit http://developer.yahoo.net/?fr=offad-ysdn-ostg-q22005
_______________________________________________
Care2002-developers mailing list
Care2002-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/care2002-developers
