Re: Syntax problem!

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: Syntax problem!
Date: 2003-04-03 08:40:42
Message-ID: 3E8BF38A.4020302@rodos.fzk.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Browse pgsql-sql by date

  From Date Subject
Next Message =?ISO-8859-1?Q?Antti_Ij=E4s?= 2003-04-03 09:16:40 Foreign key from another database
Previous Message mohamed imdadullah 2003-04-03 07:55:22 Syntax problem!