Re: [BUGS] General Bug Report: empty SELECT WHEREs return error - Mailing list pgsql-bugs

From Austin Schutz
Subject Re: [BUGS] General Bug Report: empty SELECT WHEREs return error
Date
Msg-id 19990623131844.A27977@habit.com
Whole thread Raw
In response to Re: [BUGS] General Bug Report: empty SELECT WHEREs return error  (Fomichev Michael <fomichev@null.ru>)
List pgsql-bugs
>You should use a single quotes:
>create table foo (bar char(1));
>select * from foo where bar='baz';
>bar
>---
>(0 rows)

    Ah, didn't realize double quotes were a non-portable feature of
MySQL. This will add several extra days to the effort of porting to
Postgres.
    Sigh.

    Thanks for your help,

    Austin

pgsql-bugs by date:

Previous
From: Fomichev Michael
Date:
Subject: Re: [BUGS] General Bug Report: empty SELECT WHEREs return error
Next
From: Trevor Astrope
Date:
Subject: Notice Deadlock detected and Backend cache invalidation initialization failed