X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 004A5475458 for ; Thu, 3 Apr 2003 03:41:01 -0500 (EST) Received: from fzkmail2.fzk.de (fzkmail2.fzk.de [141.52.27.52]) by postgresql.org (Postfix) with SMTP id 8C45C474E44 for ; Thu, 3 Apr 2003 03:40:43 -0500 (EST) Received: FROM resy5.fzk.de BY fzkmail2.fzk.de ; Thu Apr 03 10:40:43 2003 +0200 Received: œby rodos.fzk.de with ESMTP (8.8.6 (PHNE_17135)/8.7.1) id KAA01696; Thu, 3 Apr 2003 10:40:42 +0200 (METDST) Message-ID: <3E8BF38A.4020302@rodos.fzk.de> Date: Thu, 03 Apr 2003 10:40:42 +0200 From: Christoph Haller User-Agent: Mozilla/5.0 (X11; U; HP-UX 9000/780; en-US; rv:1.3) Gecko/20030321 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Cc: imdad_md@hotmail.com Subject: Re: Syntax problem! Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Spam-Status: No, hits=-12.1 required=5.0 tests=BAYES_10,USER_AGENT_MOZILLA_UA autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/31 X-Sequence-Number: 12732 > > 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