quoted variables in pgsql

From: chester c young <chestercyoung(at)yahoo(dot)com>
To: sql pgsql <pgsql-sql(at)postgresql(dot)org>
Subject: quoted variables in pgsql
Date: 2007-01-05 03:21:03
Message-ID: 20070105032103.61634.qmail@web54310.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2007-01-05 03:26:08 Re: quoted variables in pgsql
Previous Message Dave Steinberg 2007-01-03 16:20:47 Re: [SQL NOTIFY Help] sending NOTIFY to the external program