Hallo Bruno,
Am Montag, 27. Juli 2009 15:50 schrieb Bruno Scovoli Santos:
>...
> brunodb=# \set nom 'Intel'
> euclidhardware=# select * from fabricantes where nome like :nom;
> ERROR: column "intel" does not exist
> LINE 1: select * from fabricantes where nome like Intel;
>
> Please, I have trie
"Bruno Scovoli Santos" writes:
> brunodb=# \set nom 'Intel'
> euclidhardware=# select * from fabricantes where nome like :nom;
> ERROR: column "intel" does not exist
> LINE 1: select * from fabricantes where nome like Intel;
If you want to put quotes in the value of a variable, you need
this
\se
The following bug has been logged online:
Bug reference: 4944
Logged by: Bruno Scovoli Santos
Email address: bruno.scov...@gmail.com
PostgreSQL version: 8.3.7
Operating system: Ubuntu 9.04 Jaunty Jackalope
Description:Problems with using \set variables as strings in s
