pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedweird SQL statement question
3+ messages / 3 participants
[nested] [flat]
* weird SQL statement question
@ 2005-04-23 17:55 Tadej Kanizar <Tadej.Kanizar@sagit-server.com>
0 siblings, 1 reply; 3+ messages in thread
From: Tadej Kanizar @ 2005-04-23 17:55 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: weird SQL statement question
@ 2005-04-23 18:30 Frank Bax <fbax@sympatico.ca>
parent: Tadej Kanizar <Tadej.Kanizar@sagit-server.com>
0 siblings, 1 reply; 3+ messages in thread
From: Frank Bax @ 2005-04-23 18:30 UTC (permalink / raw)
To: pgsql-sql
At 01:55 PM 4/23/05, Tadej Kanizar wrote:
>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
If you create a table using quotes and mixed-case, you will need quotes
every time you reference the table. Don't use quotes when you create the
table and you won't need them when you acces the table with other commands.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: weird SQL statement question
@ 2005-04-23 23:57 Mischa Sandberg <mischa.sandberg@telus.net>
parent: Frank Bax <fbax@sympatico.ca>
0 siblings, 0 replies; 3+ messages in thread
From: Mischa Sandberg @ 2005-04-23 23:57 UTC (permalink / raw)
To: Frank Bax <fbax@sympatico.ca>; +Cc: pgsql-sql
Quoting Frank Bax <fbax@sympatico.ca>:
> At 01:55 PM 4/23/05, Tadej Kanizar wrote:
>
> >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!
> If you create a table using quotes and mixed-case, you will need
> quotes
> every time you reference the table. Don't use quotes when you
create
> the
> table and you won't need them when you acces the table with other
> commands.
I don't suppose that the original poster actually named the table
"table"? In which case, being a keyword, it will ALWAYS need quotes.
"Dreams come true, not free." -- S.Sondheim, ITW
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2005-04-23 23:57 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-04-23 17:55 weird SQL statement question Tadej Kanizar <Tadej.Kanizar@sagit-server.com>
2005-04-23 18:30 ` Frank Bax <fbax@sympatico.ca>
2005-04-23 23:57 ` Mischa Sandberg <mischa.sandberg@telus.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox