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