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