weird SQL statement question

Поиск
Список
Период
Сортировка
От Tadej Kanizar
Тема weird SQL statement question
Дата
Msg-id 1057768D27BE@sagit-server.com
обсуждение исходный текст
Ответы Re: weird SQL statement question  (Frank Bax <fbax@sympatico.ca>)
Список 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 по дате отправления:

Предыдущее
От: Geoffrey
Дата:
Сообщение: Re: [despammed] Insert psql commands inside a script
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: can a function return a virtual table?