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