Syntax problem!

Поиск
Список
Период
Сортировка
От mohamed imdadullah
Тема Syntax problem!
Дата
Msg-id F11KeD59KuERIqVDokS00003edd@hotmail.com
обсуждение исходный текст
Список 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
explicitcast
 

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



В списке pgsql-sql по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: simple trigger question ...
Следующее
От: Christoph Haller
Дата:
Сообщение: Re: Syntax problem!