Re: how to select
On 7/29/05, Jonathan Villa <jvilla@innovativesource.net> wrote:
now I want to select
#select someColumn from testtableI get nothing... no output, nothing...
Try terminating the statement with ';'?
Import Notes
Reply to msg id not found: 24238.216.125.144.21.1122661136.squirrel@mail.innovativesource.netReference msg id not found: 24238.216.125.144.21.1122661136.squirrel@mail.innovativesource.net
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...
-Jonathan
<quote who="Brian Wong">
Show quoted text
On 7/29/05, Jonathan Villa <jvilla@innovativesource.net> wrote:
now I want to select
#select someColumn from testtableI get nothing... no output, nothing...
Try terminating the statement with ';'?
On 7/29/05, Jonathan Villa <jvilla@innovativesource.net> 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 ;)
-Jonathan
<quote who="Jaime Casanova">
On 7/29/05, Jonathan Villa <jvilla@innovativesource.net> 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 ;)
I feel about this small -> .
Of course it's the semicolon... I guess I'm just used to MySQL where I would get this
select user from table (hit enter)
->