Re: Intermittent Empty return

[John Mulkerin <jmulkerin(at)comcast(dot)net>]

Thanks a lot.

Scott Marlowe wrote:
> On 9/22/07, John Mulkerin <jmulkerin(at)comcast(dot)net> wrote:
>   
> > I agree its old.   I'm working on the upgrade but first need to verify
> > and then purge some data.
> >
> > I tried with and without a semicolon
> >
> > However, with a semicolon results in
> >
> > Just tried semicolon again..   First time resulted in results.  Second
> > time resulted in
> > select * from survey_results;
> > ERROR:  parser: parse error at or near "select" at character 30.
> > Maybe another reason I need to upgrade?
> >     
>
> That's because what it's doing it running this:
> select * from table select * from table;
>
> i.e. it's seeing the first one you typed without the semicolon then
> second one too.
>
> You'll notice the prompt looks like this;
>
> dbname => select * from table
> dbname -> select * from table;
>
> notice the ->  That means there's already something in the buffer.
>
> \r resets the buffer.  Just try it with ONLY the semicolon and it'll work.
>
> and yeah, get to work on that upgrade... :)
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>                http://archives.postgresql.org
>
>