problems with query
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
-----------------------------------------------------------------
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."
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
Show quoted text
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
-----------------------------------------------------------------