Thread: Syntax problem!

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
explicitcast
 

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

>> I am moving the database from sybase to postgresql.Iam having problem> replacing the following similar syntax from
sybaseto 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
somereplacement in postgres, i havent been 
 
able to> find it though. I would appreciate if anybody could help me out.>
There is no such table. Alternatively use SELECT version() ;
I am not familiar with sybase. What does the '?' operator do?
What are you achieving by this statement?

Regards, Christoph

Hi Christof,

Thanx for the reply,

I think i had put up the question pretty vauge. I didn't want to get the 
version of the database. I was just trying to specify an example of the call 
to the database and the error which i was getting.

However, finally i managed to findout the error. Actually, the call to the 
database was from an  application written in 'C'. The parameters used to 
access the database followed the old ODBC 1.0 standard and SYBASE had no 
problem understanding it but was promptly refused by postgres with the 
specified error!

thanx again!


----------------------------------------------------------------------
Mohamed Imdadullah
M.S student in Information & Communication Systems
Technical University Hamburg-Harburg
Hamburg, Germany
Email: md.imdadullah@tuhh.de or imdad_md@hotmail.com
----------------------------------------------------------------------




----Original Message Follows----
From: Christoph Haller <ch@rodos.fzk.de>
To: pgsql-sql@postgresql.org
CC: imdad_md@hotmail.com
Subject: Re: [SQL] Syntax problem!
Date: Thu, 03 Apr 2003 10:40:42 +0200
>> I am moving the database from sybase to postgresql.Iam having problem> replacing the following similar syntax from
sybaseto 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
replacementin postgres, i havent been able 
 
to> find it though. I would appreciate if anybody could help me out.>
There is no such table. Alternatively use SELECT version() ;
I am not familiar with sybase. What does the '?' operator do?
What are you achieving by this statement?

Regards, Christoph



_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*. 
http://join.msn.com/?page=features/featuredemail