On Tue, Jun 4, 2019 at 3:30 PM Lou <lou@xxxxxxxxxxxxxxxxxxxxxx> wrote:
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'
Something like the following should work:
ALTER TABLE ... ALTER COLUMN ... TYPE text USING (CASE WHEN ... THEN 's' ELSE 'f' END);
Though at this point you are probably better off creating a category table with a primary key and converting this column to be a foreign key.
David J.
