On Nov 28, 2008, at 5:09 PM, Andrew Dunstan wrote:
Speaking of other sorts of derived types: might they include
something just like enums, but sorting on the string values defined
for the enum rather than on the order in which the values were
defined in the enum? I'd use something like that all the time…
order by foo_enum::text ...
Ah, I didn't realize that. I guess I'd have to index it on ::text,
too. And then, to use the index in WHERE clauses, I'd further have to
compare to ::text, eh?
Best,
David
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
