Re: Converting yes or no to one letter strings.

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Converting yes or no to one letter strings.
Date: 2019-06-04 23:01:11
Message-ID: alpine.LNX.2.20.1906041558510.12623@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 4 Jun 2019, Lou wrote:

> 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,

I'm far from an expert so take my comments with a bag of salt. First,
'false' is displayed in a column as 'f' when you look at a table with psql.
'true' is displayed as 't'.

Second, if you need to display to the user something other than 't' and 'f'
that should be done with your UI, not by changing postgres.

Regards,

Rich

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ray O'Donnell 2019-06-04 23:03:06 Re: Converting yes or no to one letter strings.
Previous Message Lou 2019-06-04 22:29:58 Converting yes or no to one letter strings.