"D'Arcy" "J.M." Cain <darcy(at)druid(dot)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
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 1999-02-11 15:36:47|
|Subject: Re: [HACKERS] PQsocket |
|Previous:||From: Oleg Broytmann||Date: 1999-02-11 15:30:13|
|Subject: Re: your mail|
pgsql-sql by date
|Next:||From: Hannu Krosing||Date: 1999-02-11 17:39:47|
|Subject: Re: [HACKERS] Re: [SQL] RULE questions.|
|Previous:||From: Thomas Schoessow||Date: 1999-02-11 14:48:48|