Re: how to select

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">
> On 7/29/05, Jonathan Villa <jvilla@innovativesource.net> wrote:
>> now I want to select
>> #select someColumn from testtable
>>
>> I get nothing... no output, nothing...
>
> Try terminating the statement with ';'?
>