Re: how to select

On Fri, 2005-07-29 at 14:48, Jonathan Villa wrote:
> -Jonathan
> >>
> >>
> >
> > 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)
> ->

No biggie. Postgresql is just a little more subtle:

test=> select * from test
test->

Notice the switch from => to ->