Re: Syntax problem!

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(dot)imdadullah(at)tuhh(dot)de or imdad_md(at)hotmail(dot)com
----------------------------------------------------------------------

----Original Message Follows----
From: Christoph Haller <ch(at)rodos(dot)fzk(dot)de>
To: pgsql-sql(at)postgresql(dot)org
CC: imdad_md(at)hotmail(dot)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