Received: from web20805.mail.yahoo.com (web20805.mail.yahoo.com [216.136.226.194]) by postgresql.org (8.11.3/8.11.4) with SMTP id fAJLgsm87501 for ; Mon, 19 Nov 2001 16:42:54 -0500 (EST) (envelope-from jeff_eckermann@yahoo.com) Message-ID: <20011119214255.26317.qmail@web20805.mail.yahoo.com> Received: from [65.11.165.34] by web20805.mail.yahoo.com via HTTP; Mon, 19 Nov 2001 13:42:55 PST Date: Mon, 19 Nov 2001 13:42:55 -0800 (PST) From: Jeff Eckermann Subject: Re: why does this query does not work?????? To: satya pariki , pgsql-sql@postgresql.org In-Reply-To: <20011115161805.56523.qmail@web21102.mail.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200111/274 X-Sequence-Number: 5656 If you are using psql (command line client), you can use: \set variable_name variable_value Then refer to the value by ":variable_name", i.e. colon instead of ampersand. "man psql" for more information. --- satya pariki wrote: > 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 > > ---------------------------(end of > broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org __________________________________________________ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com