Search Postgresql Archives

Re: how to select

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 7/29/05, Jonathan Villa <jvilla@xxxxxxxxxxxxxxxxxxxx> wrote:
> 
> Ok, this is odd...
> 
> I tried ending with a semicolon before, and received this error
> 
> ERROR:  parser: parse error at or near "select"
> 
> I have to do it twice before I get it works...here's an example
> 
> select project_name from project_group_list;
> ERROR:  parser: parse error at or near "select"
> select project_name from project_group_list;
> ...
> ...
> ...
> 
> that's odd...
> 
> 

that's because you type a select without a semicolon then you write
one with the semicolon so the parser think both are only one command
but refused to execute that bad formed sentence and give you the
error... then you put another sentence and, of cuorse it executed...

you just show us 2 sentences one before the error and one after...

am i right?

-- 
Atentamente,
Jaime Casanova
(DBA: DataBase Aniquilator ;)

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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux