Re: Converting yes or no to one letter strings.
От
Ray O'Donnell
Тема
Re: Converting yes or no to one letter strings.
Дата
Msg-id
16b24bb5810.280a.f9dd809031fc0469edf0bbbf79c1d468@rodonnell.ie
Ответ на
Список
Дерево обсуждения
Converting yes or no to one letter strings. Lou <lou@dayspringpublisher.com>
Re: Converting yes or no to one letter strings. "Ray O'Donnell" <ray@rodonnell.ie>
Re: Converting yes or no to one letter strings. Rich Shepard <rshepard@appl-ecosys.com>
Re: Converting yes or no to one letter strings. "David G. Johnston" <david.g.johnston@gmail.com>
Re: Converting yes or no to one letter strings. Rich Shepard <rshepard@appl-ecosys.com>
Re: Converting yes or no to one letter strings. Adrian Klaver <adrian.klaver@aklaver.com>
Re: Converting yes or no to one letter strings. Ron <ronljohnsonjr@gmail.com>
Re: Converting yes or no to one letter strings. Adrian Klaver <adrian.klaver@aklaver.com>
Re: Converting yes or no to one letter strings. Christopher Browne <cbbrowne@gmail.com>
Re: Converting yes or no to one letter strings. "David G. Johnston" <david.g.johnston@gmail.com>
On 4 June 2019 23:30:33 Lou <lou@dayspringpublisher.com> 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.
Lou
select case when (boolean variable) then (whatever) else (whatever else) end;
В списке pgsql-general по дате отправления
