From: | Olivier Gautherot <ogautherot(at)gautherot(dot)net> |
---|---|
To: | stan <stanb(at)panix(dot)com> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Handling case variatiions on a user defined type? |
Date: | 2019-09-15 12:58:45 |
Message-ID: | CAJ7S9TUCF332G2frcmCay-ayFPX-sOo8hz6-Cqkx16sZiG0P9g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
El dom., 15 de septiembre de 2019 09:37, stan <stanb(at)panix(dot)com> escribió:
> I have several enumerated types that look like:
>
> CREATE TYPE confidence_level AS ENUM ('HIGH' ,
> 'MEDIUM' ,
> 'LOW' ,
> 'WAG');
>
>
> I have someone creating data for this project in spreadsheets, and then am
> importing the data using \copy.
>
> Problem is the data in the spreadsheets is entered in mixed case.
>
> Is there a way that I can use the type itself, to enforce something like a
> to_upper(). Or is there a better way to "human proof" this?
>
> --
> "They that would give up essential liberty for temporary safety deserve
> neither liberty nor safety."
> -- Benjamin Franklin
>
What about a trigger on INSERT, which would enforce the case?
>
From | Date | Subject | |
---|---|---|---|
Next Message | stan | 2019-09-15 13:26:21 | Re: Handling case variatiions on a user defined type? |
Previous Message | stan | 2019-09-15 12:37:31 | Handling case variatiions on a user defined type? |