weird SQL statement question

From: "Tadej Kanizar" <Tadej(dot)Kanizar(at)sagit-server(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: weird SQL statement question
Date: 2005-04-23 17:55:29
Message-ID: 1057768D27BE@sagit-server.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Ok, so I installed the latest version of Postresql (8.02) on a WinXP SP2
machine..

My question is why won't the statement SELECT * FROM table work, whereas the
statement SELECT * FROM »table« works!

And, to explain a bit more, here's another example:

INSERT INTO TestTable (Name, Surname) VALUES ('name', 'surname'); .. this
DOESN'T work

INSERT INTO »TestTable« (»Name«, »Surname«) VALUES ('name', 'surname'); ..
this DOES work

Any ideas? :-)

Regards,

Tadej

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2005-04-23 18:00:56 Re: can a function return a virtual table?
Previous Message Geoffrey 2005-04-23 13:46:20 Re: [despammed] Insert psql commands inside a script