X-Original-To: pgsql-sql@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 749BC475CEE
	for <pgsql-sql@postgresql.org>; Thu,  3 Apr 2003 02:55:24 -0500 (EST)
Received: from hotmail.com (f11.law11.hotmail.com [64.4.17.11])
	by postgresql.org (Postfix) with ESMTP id B9C86476396
	for <pgsql-sql@postgresql.org>; Thu,  3 Apr 2003 02:55:23 -0500 (EST)
Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC;
	Wed, 2 Apr 2003 23:55:23 -0800
Received: from 217.235.100.141 by lw11fd.law11.hotmail.msn.com with HTTP;
	Thu, 03 Apr 2003 07:55:22 GMT
X-Originating-IP: [217.235.100.141]
X-Originating-Email: [imdad_md@hotmail.com]
From: "mohamed imdadullah" <imdad_md@hotmail.com>
To: pgsql-sql@postgresql.org
Subject: Syntax problem!
Date: Thu, 03 Apr 2003 07:55:22 +0000
Mime-Version: 1.0
Content-Type: text/plain; format=flowed
Message-ID: <F11KeD59KuERIqVDokS00003edd@hotmail.com>
X-OriginalArrivalTime: 03 Apr 2003 07:55:23.0170 (UTC)
	FILETIME=[614E9820:01C2F9B6]
X-Spam-Status: No, hits=-3.1 required=5.0
	tests=BAYES_20
	version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200304/30
X-Sequence-Number: 12731


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