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@math.unl.edu.ar
Santa Fe - Argentina		http://math.unl.edu.ar/~martin/
Administrador de sistemas en math.unl.edu.ar
-----------------------------------------------------------------

Wed, 20 Dec 2000 17:23:20 -0300
"Martin A. Marques" <martin@math.unl.edu.ar>
problems with query
>INSERT INTO ciudad (ciudad) VALUES ("Villa Guillermina")

Use single quotes instead of double quotes.


-- 
- Thomas Swan
- Graduate Student  - Computer Science
- The University of Mississippi
-
- "People can be categorized into two fundamental
- groups, those that divide people into two groups
- and those that don't."

INSERT INTO ciudad (ciudad) VALUES
("Villa Guillermina")
Use single quotes instead of double quotes.



-- 
- Thomas Swan
                                  
- Graduate Student  - Computer Science
- The University of Mississippi
- 
- "People can be categorized into two fundamental 
- groups, those that divide people into two groups 
- and those that don't."
Wed, 20 Dec 2000 14:26:16 -0600
Thomas Swan <tswan-lst@ics.olemiss.edu>
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@math.unl.edu.ar
>Santa Fe - Argentina		http://math.unl.edu.ar/~martin/
>Administrador de sistemas en math.unl.edu.ar
>-----------------------------------------------------------------

Thu, 21 Dec 2000 10:24:09 +0530
Anand Raman <araman@india-today.com>
Re: problems with query