Re: Case Insensitive Data Type

From: Fran Fabrizio <ffabrizio(at)mmrd(dot)com>
To: Russell Black <russell(dot)black(at)iarchives(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Case Insensitive Data Type
Date: 2002-05-24 17:21:43
Message-ID: 3CEE76A7.9060401@mmrd.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
> Does anyone know of a case-insensitive data type? I'd want the
> following behavior:

sounds like you want some combination of the built-in lower() function
and a trigger or rule to ensure lower on insert.

-Fran

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Doug Fields 2002-05-24 17:26:53 Re: Postgres under CygWin
Previous Message Doug Fields 2002-05-24 17:20:43 Efficiency question: VARCHAR with empty string vs NULL