Hi,
Would like to report a problem that happened with a
friend mine. I was to inquire and I found the
following one.

--
db=# create table teste (desc varchar(50));
ERROR: parser: parse error at or near "desc" at
character 21
db=# create table desc (teste varchar(50));
ERROR: parser: parse error at or near "desc" at
character 14
db=# create table table (teste varchar(50));
ERROR: parser: parse error at or near "table" at
character 14
db=# create table teste (table varchar(50));
ERROR: parser: parse error at or near "table" at
character 21
--

Aldrey


__________________________________________________ ____________________

Yahoo! Messenger - Fale com seus amigos online. Instale agora!
http://br.download.yahoo.com/messenger/

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

=?iso-8859-1?q?Aldrey=20Galindo?= <aldreygalindo (AT) yahoo (DOT) com.br> writes:
DESC is a reserved keyword, per the SQL specification.

If you really really want to name your column or table "desc", you can
double-quote the word. But I'd suggest picking another name.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

On Wed, 28 Apr 2004, [iso-8859-1] Aldrey Galindo wrote:

DESC and TABLE are reserved words in SQL, so you need to double
quote them to use them as column or table names.


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly