From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Jan Urbański <j(dot)urbanski(at)students(dot)mimuw(dot)edu(dot)pl> |
Cc: | Mark Mielke <mark(at)mark(dot)mielke(dot)cc>, Nick <nboutelier(at)hotmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Creating a VIEW with a POINT column |
Date: | 2008-06-26 04:02:05 |
Message-ID: | 4507.1214452925@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
=?UTF-8?B?SmFuIFVyYmHFhHNraQ==?= <j(dot)urbanski(at)students(dot)mimuw(dot)edu(dot)pl> writes:
> Same thing for GROUP BY.
Yeah. The GROUP BY case is even more annoying, because we *have* the
planner/executor infrastructure to do it via hashing; but the parser
barfs immediately if there is not btree opclass support for the type.
I'm not sure how to fix the parser and the parsetree representation
to be agnostic about hash versus sort implementations --- any thoughts?
> ... One last remark: unless something is done about
> it in 8.4, maybe it is worthwhile to change the error message (which
> clearly confused Nick) and add some documentation about why you can't
> use DISTINCT with types without a btree index opclass?
IIRC, the error message is correct for some other cases, so it might be
hard to fix it without taking two steps backward overall. But feel free
to take a look if you want to. Nuthin wrong with more documentation
either ...
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-06-26 05:23:18 | Re: Planner creating ineffective plans on LEFT OUTER joins |
Previous Message | Bruce Momjian | 2008-06-26 03:58:09 | Re: [0/4] Proposal of SE-PostgreSQL patches |