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
Message-ID: <F60LQsJABSCu6U5QH6P0000ac52@hotmail.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: imdad_md@hotmail.com, ch@rodos.fzk.de
Subject: Re: Syntax problem!
In-Reply-To: <F60LQsJABSCu6U5QH6P0000ac52@hotmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox