Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 8E44D9FA131 for ; Thu, 4 Jan 2007 23:21:07 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 90260-01 for ; Thu, 4 Jan 2007 23:21:00 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from web54310.mail.yahoo.com (web54310.mail.yahoo.com [206.190.49.120]) by postgresql.org (Postfix) with SMTP id 6048E9FA0B7 for ; Thu, 4 Jan 2007 23:21:06 -0400 (AST) Received: (qmail 61636 invoked by uid 60001); 5 Jan 2007 03:21:03 -0000 Message-ID: <20070105032103.61634.qmail@web54310.mail.yahoo.com> DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=Jr+tB3Lv3DpzRHrG40QQCh6qr8KlHk8MgypQVK3A8yDCWoFs8vdLtn7dzHDXEdK4M2MB7aHPOS9/Gbv94wtCYkJksvrSv1EUKuL9EaIInTkzscxJU/Fniwan9EPktAl0szBfJDinjeDCKjc0bs9IEK4d77UhIurweu2xjgeoBFw=; X-YMail-OSG: 1Hqm0pgVM1l9Qt202_PanqlBYJYwcSMcgxggvm.LO76Ak3UpHcWD3RzrKjze9w1yllGm0._vXSsgd2SFIWj6gxugH8DeXGLCkG4q2nKrMoQVSbYSmU8tb7xEaRmiYHF5XkN0l9Ulaci8nP2_P39YH3yl4etAK6tuSP8xePcf8LKDMchOVB3nBLITKw4- Received: from [24.10.123.39] by web54310.mail.yahoo.com via HTTP; Thu, 04 Jan 2007 19:21:03 PST Date: Thu, 4 Jan 2007 19:21:03 -0800 (PST) From: chester c young Subject: quoted variables in pgsql To: sql pgsql MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/9 X-Sequence-Number: 27161 cannot figure this out # \set var 'value' # select * from some_table where some_col = :var; ERROR: column value does not exist cannot get those quotes around the value. tried: # \set var ''value'' # \set var ''''value'''' in each case: # \echo :var value thanks __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com