On Mon, 2011-06-20 at 12:54 -0700, Darren Duncan wrote: > That DOMAIN-based solution ostensibly sounds like a good one then, under the > circumstances.
It's not bad from a theoretical standpoint, but it does require some extra type annotation, which is not really the "SQL way". > What I *don't* want to see is for things like ranges to have > their own collations and the like. I'm not 100% sure what you mean here. If you mean that you don't want range types to pay attention to COLLATE clauses, etc., then I agree. I would also agree if you mean that range values should not carry the collation with them. However, it looks like we might try to make the opclass/collation pair a property of the range type definition. That seems nice, because it allows us to keep the nice properties of ranges as well as the type inference and polymorphism for everything except the constructors. Regards, Jeff Davis -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers