Re: Converting yes or no to one letter strings. - Mailing list pgsql-general

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



> 
> Lou
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com