Re: how to select - Mailing list pgsql-general

From Scott Marlowe
Subject Re: how to select
Date
Msg-id 1122666134.32465.65.camel@state.g2switchworks.com
Whole thread Raw
In response to Re: how to select  ("Jonathan Villa" <jvilla@innovativesource.net>)
List pgsql-general
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 ->

pgsql-general by date:

Previous
From: "Jonathan Villa"
Date:
Subject: Re: how to select
Next
From: "Jim C. Nasby"
Date:
Subject: Re: [pgsql-advocacy] MySQL to PostgreSQL, was ENUM type