"Kevin Grittner" <kevin.gritt...@wicourts.gov> writes: > Simon Riggs <si...@2ndquadrant.com> 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 (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers