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 tried exaustively many other ways to achieve this result, > and searched many foruns. I dont realize where is my error, I think that it > is a bug? > > Thanks in advance, > > Bruno The syntax for \set with strings is a bit bizarre. You have to use either \set nom '\'Intel\'' or \set nom '''Intel''' cu Rolf Jentsch Entwicklung Mitglieder-Systeme Dezentral ElectronicPartner GmbH Mündelheimer Weg 40 40472 Düsseldorf phone: +49-(0)211-4156-0 fax: +49-(0)211-4156-6865 eMail: rjent...@electronicpartner.de Sitz der Gesellschaft Düsseldorf Amtsgericht - Registergericht Düsseldorf - HRB 4078 Geschäftsführer: Dr. Jörg Ehmer, Oliver Haubrich, Dr. Sven-Olaf Krauß, Karl Trautmann -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
