| 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: | Whole Thread | Raw Message | 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! |