Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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

pgsql-hackers by date

Next:From: Tom LaneDate: 1999-02-11 15:36:47
Subject: Re: [HACKERS] PQsocket
Previous:From: Oleg BroytmannDate: 1999-02-11 15:30:13
Subject: Re: your mail

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group