weird SQL statement question - Mailing list pgsql-sql

From Tadej Kanizar
Subject weird SQL statement question
Date
Msg-id 1057768D27BE@sagit-server.com
Whole thread Raw
Responses Re: weird SQL statement question
List pgsql-sql
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span lang="SL" style="font-size:10.0pt;
font-family:Arial">Ok, so I installed the latest version of Postresql (8.02) on a WinXP SP2 machine.. </span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span lang="SL" style="font-size:10.0pt; 
font-family:Arial">My question is why won't the statement SELECT * FROM table work, whereas the statement SELECT * FROM
»table«works!</span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="SL" style="font-size:10.0pt; 
font-family:Arial">And, to explain a bit more, here's another example:</span></font><p class="MsoNormal"><font
face="Arial"size="2"><span lang="SL" style="font-size:10.0pt; 
font-family:Arial">INSERT INTO TestTable (Name, Surname) VALUES ('name', 'surname');  .. this DOESN'T
work</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span lang="SL" style="font-size:10.0pt; 
font-family:Arial">INSERT INTO »TestTable« (»Name«, »Surname«) VALUES ('name', 'surname'); .. this DOES
work</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span lang="SL" style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="SL"
style="font-size:10.0pt;
font-family:Arial">Any ideas? </span></font><font face="Wingdings" size="2"><span lang="SL"
style="font-size:10.0pt;font-family:Wingdings">J</span></font><fontface="Arial" size="2"><span lang="SL"
style="font-size:10.0pt;font-family:Arial"></span></font><pclass="MsoNormal"><font face="Arial" size="2"><span
lang="SL"style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="SL"
style="font-size:10.0pt;
font-family:Arial">Regards,</span></font><p class="MsoNormal"><font face="Arial" size="2"><span lang="SL"
style="font-size:10.0pt;
font-family:Arial">Tadej</span></font></div>

pgsql-sql by date:

Previous
From: Geoffrey
Date:
Subject: Re: [despammed] Insert psql commands inside a script
Next
From: Josh Berkus
Date:
Subject: Re: can a function return a virtual table?