Received: from avalon.netcom.net.uk (root@avalon.netcom.net.uk [194.42.225.7]) by hub.org (8.8.8/8.7.5) with ESMTP id GAA24501 for ; Thu, 3 Sep 1998 06:49:21 -0400 (EDT) Received: from netcomuk.co.uk (dialup-07-16.netcomuk.co.uk [194.42.229.208]) by avalon.netcom.net.uk (8.8.8/8.8.8) with ESMTP id LAA16548 for ; Thu, 3 Sep 1998 11:49:19 +0100 (BST) Sender: root@avalon.netcom.net.uk Message-ID: <35EE83FD.426DC43F@netcomuk.co.uk> Date: Thu, 03 Sep 1998 11:56:45 +0000 From: Ronnie Doggart Organization: Trinity Group Ltd. X-Mailer: Mozilla 4.05 [en] (X11; I; Linux 2.0.34 i586) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Forming Query Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi All, I want to prompt a user for information in a query. In Oracle the format would be select part_no, description from pricing where part_no like '&1'; what is it using psql and postgresql. Regards Ronnie Doggart