Re: problems with query

hi
Try to use single quotes rather than double quotes..
INSERT INTO ciudad (ciudad) VALUES ('Villa Guillermina');
rather than
INSERT INTO ciudad (ciudad) VALUES ("Villa Guillermina");

Hope this helps
Anand

On Wed, Dec 20, 2000 at 05:23:20PM -0300, Martin A. Marques wrote:
>Hi, I have this table on postgres-7.0.3
>
>CREATE TABLE ciudad (
> id_ciudad SERIAL,
> ciudad VARCHAR(60)
>);
>
>GRANT ALL ON ciudad TO martin;
>
>CREATE INDEX ciudad_idx ON ciudad (ciudad);
>
>And I try to insert a value using this query:
>
>INSERT INTO ciudad (ciudad) VALUES ("Villa Guillermina")
>
>getting as responce the message:
>
>ERROR: Attribute 'Villa Guillermina' not found.
>
>The field ciudad is of type varchar(60), so I don't get why it gives me this
>message.
>
>Any ideas?
>
>
>--
>System Administration: It's a dirty job,
>but someone told I had to do it.
>-----------------------------------------------------------------
>Martín Marqués email: martin(at)math(dot)unl(dot)edu(dot)ar
>Santa Fe - Argentina http://math.unl.edu.ar/~martin/
>Administrador de sistemas en math.unl.edu.ar
>-----------------------------------------------------------------