Re: upper case constraint?

From: Pedro Alves <pmalves(at)think(dot)co(dot)pt>
To: "Gowey, Geoffrey" <ggowey(at)rxhope(dot)com>
Cc: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: upper case constraint?
Date: 2001-09-25 19:01:03
Message-ID: 20010925190103.A4691@cosmos.inesc.pt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


One turnarround solution I use for that is to make the convertion to
uppercase in the script prior to the insertion. If that is your case, u can
do that too. Nevertheless, it seem easy to make a function toupper(), if it
does not exists yet

On Tue, Sep 25, 2001 at 12:43:58PM -0400, Gowey, Geoffrey wrote:
> Just wondering if anyone knows off hand how to make it so all inserts on a
> column will wind up being tranparently stored as uppercase (ex: ee1234567 =
> EE1234567).
>
> Geoff
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

--
Pedro Miguel G. Alves

THINK - Tecnologias de Informação
Av. Defensores de Chaves nº 15 4ºD, 1000-109 Lisboa Portugal
Tel: +351 21 3590285 Fax: +351 21 3582729
HomePage: www.think.co.pt

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jan Wieck 2001-09-25 19:27:58 Re: Practical Cursors
Previous Message Tony Reina 2001-09-25 18:59:20 Re: [HACKERS] not on .hackers