Re:ORDER BY

>From the CVS version of a day or two ago, I'm getting errors on the
following queries, which worked from a snapshot from about a month ago.
One it is rejecting apparently valid syntax. One the backend is
crashing.

SELECT category.oid, category.title FROM category*, urllink WHERE
urllink.category=category.oid AND category.category IS NULL GROUP BY
category.title, category.oid;
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
We have lost the connection to the backend, so further processing is
impossible. Terminating.

SELECT category.oid, category.title FROM category*, urllink WHERE
urllink.category=category.oid AND category.category IS NULL UNION SELECT
c1.oid, c1.title FROM category* c1, category* c2, urllink WHERE
c1.category IS NULL AND urllink.category = c2.oid and c1.oid =
c2.category GROUP BY c1.title UNION SELECT c1.oid, c1.title FROM
category* c1, story WHERE story.category = c1.oid ORDER BY
category.title;
ERROR: Illegal use of aggregates or non-group column in target list

--
Chris Bitmead
http://www.bigfoot.com/~chris.bitmead
mailto:chris(dot)bitmead(at)bigfoot(dot)com