"Kevin Grittner" <[email protected]> writes:
> Simon Riggs <[email protected]> wrote:
>> select count(*)
>> from foo1 a, foo1 b
>> where a.c1 = b.c1 /* PK join */
> We had to do something like that to get acceptable performance from
> Sybase ASE.
Writing a join for a single-table query? Why, in heavens name?
(Or have you mercifully blotted the details from your memory?)
regards, tom lane
--
Sent via pgsql-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers