Postgres Pro
Downloads
Home   >   mailing lists

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

From David G. Johnston
Subject Re: Converting yes or no to one letter strings.
Date
Msg-id CAKFQuwapnGz0fQP-ZE-coP190vv_NfFWJK+f6NyneFOqH-YP2g@mail.gmail.com
Whole thread Raw
In response to Converting yes or no to one letter strings.  (Lou <lou@dayspringpublisher.com>)
List pgsql-general
Tree view
On Tue, Jun 4, 2019 at 3:30 PM Lou <lou@dayspringpublisher.com> 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);

https://www.postgresql.org/docs/11/sql-altertable.html

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.

pgsql-general by date:

Previous
From: "Ray O'Donnell"
Date:
Subject: Re: Converting yes or no to one letter strings.
Next
From: "David G. Johnston"
Date:
Subject: Re: Converting yes or no to one letter strings.