| 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: | Whole Thread | Raw Message | 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 |