From: "mohamed imdadullah" <imdad_md@hotmail.com>
To: pgsql-sql@postgresql.org
Cc: ch@rodos.fzk.de
Subject: Re: Syntax problem!
Date: Thu, 03 Apr 2003 14:23:27 +0000
Mime-Version: 1.0
Content-Type: text/plain; format=flowed
Message-ID: <F60LQsJABSCu6U5QH6P0000ac52@hotmail.com>


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