Aram Fingal wrote:
> I want to create a user defined data type but have flexible input just like,
> for example, the boolean
> data type where TRUE can be entered as any of (TRUE, true, T, t, YES, yes, Y,
> y, 1...) and it will be
> interpreted as the same thing.
>
> So suppose I have days of the week:
>
> CREATE TYPE days_of_week AS ENUM ('Su','M','Tu','W','Th','F','Sa');
>
> Except that I want 'MON', 'Mon', 'mon' and 'monday' all to be interpreted as
> 'M' in the data type.
> What is the best way to do this.? Is that what input_function is for in the
> CREATE TYPE command? Do I
> need to create a trigger?
Yes, the type input function converts the string representation to the internal
representation, so that's where you'd implement that in a user defined data
type.
Yours,
Laurenz Albe
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
