Re: [HACKERS] Re: [SQL] RULE questions.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-hackers(at)postgreSQL(dot)org
Cc: maillist(at)remo(dot)demon(dot)co(dot)uk (Neil Burrows), pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Re: [SQL] RULE questions.
Date: 1999-02-11 15:35:00
Message-ID: 14220.918747300@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-sql

"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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 1999-02-11 15:36:47 Re: [HACKERS] PQsocket
Previous Message Oleg Broytmann 1999-02-11 15:30:13 Re: your mail

Browse pgsql-sql by date

  From Date Subject
Next Message Hannu Krosing 1999-02-11 17:39:47 Re: [HACKERS] Re: [SQL] RULE questions.
Previous Message Thomas Schoessow 1999-02-11 14:48:48 unsubscribe