Re: [BUGS] General Bug Report: empty SELECT WHEREs return error

From: Austin Schutz <tex(at)habit(dot)com>
To: Fomichev Michael <fomichev(at)null(dot)ru>
Cc: pgsql-bugs(at)postgreSQL(dot)org
Subject: Re: [BUGS] General Bug Report: empty SELECT WHEREs return error
Date: 1999-06-23 20:18:45
Message-ID: 19990623131844.A27977@habit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Trevor Astrope 1999-06-28 12:05:44 Notice Deadlock detected and Backend cache invalidation initialization failed
Previous Message Fomichev Michael 1999-06-23 19:54:45 Re: [BUGS] General Bug Report: empty SELECT WHEREs return error