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
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 |
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 |