Thread

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

Austin Schutz <tex@habit.com> — 1999-06-23T20:18:45Z

>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