Hi all,


I am moving the database from sybase to postgresql.Iam having problem replacing the following similar syntax from sybase to postgres sql could anybody help me out? It doesnt seem to recognize the '?' operator though it works fine in Sybase.

select * from version where version_nr =?;
ERROR:  Unable to identify a postfix operator '=?' for type 'integer'
       You may need to add parentheses or an explicit cast

I am sure there must be some replacement in postgres, i havent been able to find it though. I would appreciate if anybody could help me out.

regards
pgsqlnovoice


_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus



---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to