Received: from web21102.mail.yahoo.com (web21102.mail.yahoo.com [216.136.227.104]) by postgresql.org (8.11.3/8.11.4) with SMTP id fAFGI2m19623 for ; Thu, 15 Nov 2001 11:18:02 -0500 (EST) (envelope-from spariki@yahoo.com) Message-ID: <20011115161805.56523.qmail@web21102.mail.yahoo.com> Received: from [65.56.123.156] by web21102.mail.yahoo.com via HTTP; Thu, 15 Nov 2001 08:18:05 PST Date: Thu, 15 Nov 2001 08:18:05 -0800 (PST) From: satya pariki Subject: why does this query does not work?????? To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200111/272 X-Sequence-Number: 5654 are there any substitution variables in postgresql ? select * from EMP where EMPNO = &empnum; it is giving error. it is telling to type cast or use parenthesis. i will be grateful if u help me out of this. bye satya __________________________________________________ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com