subject:"\[SQL\] quoted variables in pgsql"

Re: [SQL] quoted variables in pgsql

2007-01-04 Thread Tom Lane

chester c young <[EMAIL PROTECTED]> writes: > cannot get those quotes around the value. Use backslashes. regression=# \set var '\'value\'' regression=# \echo :var 'value' regards, tom lane ---(end of broadcast)--- TIP 7: Yo

[SQL] quoted variables in pgsql

2007-01-04 Thread chester c young

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 ___