Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 9F9259FB328; Wed, 7 Feb 2007 20:50:08 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 46657-04; Wed, 7 Feb 2007 20:49:52 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from bay0-omc2-s3.bay0.hotmail.com (bay0-omc2-s3.bay0.hotmail.com [65.54.246.139]) by postgresql.org (Postfix) with ESMTP id 35C279FB251; Wed, 7 Feb 2007 20:49:52 -0400 (AST) Received: from hotmail.com ([65.55.136.108]) by bay0-omc2-s3.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2668); Wed, 7 Feb 2007 16:49:51 -0800 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Wed, 7 Feb 2007 16:49:49 -0800 Message-ID: Received: from 65.55.136.123 by by131fd.bay131.hotmail.msn.com with HTTP; Thu, 08 Feb 2007 00:49:45 GMT X-Originating-IP: [67.116.31.14] X-Originating-Email: [skarthi98@hotmail.com] X-Sender: skarthi98@hotmail.com From: "Karthikeyan Sundaram" To: pgsql-admin@postgresql.org, pgsql-sql@postgresql.org Subject: question on passing parameter in sql query Date: Wed, 07 Feb 2007 16:49:45 -0800 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 08 Feb 2007 00:49:49.0960 (UTC) FILETIME=[098A3080:01C74B1B] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.106 tagged_above=0 required=5 tests=AWL, BAYES_50, MSGID_FROM_MTA_HEADER, SPF_PASS X-Spam-Level: X-Archive-Number: 200702/115 X-Sequence-Number: 24580 Hi, I don't want to compare with Oracle and postgres. But I have a situation. I am using psql command line tool supplied by postgres. In Oracle I can say select * from emp where emp_id = &1 Oracle will ask: Enter a value for 1: If I enter 10, then Oracle will get the empid=10 What is the equal command in postgres ? Regards skarthi _________________________________________________________________ Invite your Hotmail contacts to join your friends list with Windows Live Spaces http://clk.atdmt.com/MSN/go/msnnkwsp0070000001msn/direct/01/?href=http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us