On 6/4/19 7:19 PM, Adrian Klaver wrote:
> On 6/4/19 3:29 PM, Lou wrote:
>> Hi everyone,
>>
>> Is it possible to convert a boolean yes or no field to hold a one letter
>> string? For example, the strings: 's' 'f' 'p' 'e'
>>
>> To start off, I just need to convert true to 's'. false will have to be
>> manually changed to 'f' or 'p' or 'e' as appropriate.
>
> Why not an enum field?:
>
> https://www.postgresql.org/docs/11/datatype-enum.html
I thought enum was Considered Harmful because of the difficulty in altering
the enums?
--
Angular momentum makes the world go 'round.