On Jun 3, 2008, at 12:06, Zdenek Kotala wrote:
It is simple. SQL standard does not specify notation for that
(chapter 11.34). But there is proposed notation:
CREATE COLLATION <collation name> FOR <character set specification>
FROM <existing collation name> [ <pad characteristic> ] [ <case
sensitive> ] [ <accent sensitive> ] [ LC_COLLATE <lc_collate> ]
[ LC_CTYPE <lc_ctype> ]
<pad characteristic> := NO PAD | PAD SPACE
<case sensitive> := CASE SENSITIVE | CASE INSENSITIVE
<accent sensitive> := ACCENT SENSITIVE | ACCENT INSENSITIVE
You can specify for each collation if it is case sensitive or not
and collation function should be responsible to correctly handle
this flag.
Wooo! Now if only i could apply that on a per-column basis. Still,
it'll be great to have this for a whole database.
Thanks, looking forward to it.
David
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers