"D'Arcy" "J.M." Cain <darcy@druid.net> writes:
> Second, an option to CREATE INDEX to make the index case insensitive.
That, at least, we can already do: build the index on lower(field) not
just field. Or upper(field) if that seems more natural to you.
> Also, in a primary key field (or
> unique index) it would be nice if "A" was rejected if "a" already was
> in the database.
Making either of the above a UNIQUE index should accomplish that.
regards, tom lane