Re: [GENERAL] Alternate input for user defined data type

2013-08-21 Thread Albe Laurenz
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 th

[GENERAL] Alternate input for user defined data type

2013-08-20 Thread Aram Fingal
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_