On Mon, Jul 28, 2008 at 03:49:21PM -0400, Tom Lane wrote: > > I kind of assumed we would do it by implementing the COLLATE clause of > > the CREATE DOMAIN statement. > > But to define such a domain, you'd have to commit to a case-insensitive > version of a specific collation, no? citext currently means "case > insensitive version of whatever the database's default collation is". > This might be worrying over nothing significant, but I'm not > convinced...
In the version of COLLATE I did you had variations on locales (asc/desc, case (in)sensetive) which could be selected. So you could make COLLATE CASE_INSENSITIVE actually just modify the existing collation. That said, this is no more of a deal than that text also has a default collation. You talk about "the database's default collation" but with proper collation support that statement is meaningless. A database has no collation, only types, expressions and columns do. Have a nice day, -- Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/ > Please line up in a tree and maintain the heap invariant while > boarding. Thank you for flying nlogn airlines.
signature.asc
Description: Digital signature