pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedSyntax problem!
3+ messages / 2 participants
[nested] [flat]
* Syntax problem!
@ 2003-04-03 07:55 mohamed imdadullah <imdad_md@hotmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: mohamed imdadullah @ 2003-04-03 07:55 UTC (permalink / raw)
To: pgsql-sql
Hi all,
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.
regards
pgsqlnovoice
_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
http://join.msn.com/?page=features/virus
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Syntax problem!
@ 2003-04-03 08:40 Christoph Haller <ch@rodos.fzk.de>
0 siblings, 0 replies; 3+ messages in thread
From: Christoph Haller @ 2003-04-03 08:40 UTC (permalink / raw)
To: pgsql-sql; +Cc: imdad_md@hotmail.com
>
> 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Syntax problem!
@ 2003-04-03 14:23 mohamed imdadullah <imdad_md@hotmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: mohamed imdadullah @ 2003-04-03 14:23 UTC (permalink / raw)
To: pgsql-sql; +Cc: ch@rodos.fzk.de
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2003-04-03 14:23 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-04-03 07:55 Syntax problem! mohamed imdadullah <imdad_md@hotmail.com>
2003-04-03 08:40 Re: Syntax problem! Christoph Haller <ch@rodos.fzk.de>
2003-04-03 14:23 Re: Syntax problem! mohamed imdadullah <imdad_md@hotmail.com>
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