Home > mailing lists

Re: Convert boolean field to a 0 or a 1 in a select statement - Mailing list pgsql-novice

From	Sameer Kumar
Subject	Re: Convert boolean field to a 0 or a 1 in a select statement
Date	January 12, 2015 09:32:16
Msg-id	CADp-Sm7UjpUSV9JHjhwwOy1dp0ETsWqstKaPvikc6Mriuy3UwA@mail.gmail.com Whole thread Raw
In response to	Convert boolean field to a 0 or a 1 in a select statement (JORGE MALDONADO <jorgemal1960@gmail.com>)
Responses	Re: Convert boolean field to a 0 or a 1 in a select statement
List	pgsql-novice

On Sat, Jan 10, 2015 at 12:47 AM, JORGE MALDONADO <jorgemal1960@gmail.com> wrote:

CAST(fce_subdivision as CHAR) AS fce_subdivision_aux,
CASE CAST(fce_subdivision as CHAR)
WHEN 'f' THEN '0'
WHEN 't' THEN '1'
END

Why do you want to cast it first to char?

And anyways what is the issue with casting it to number first and then casting it to char?

Best Regards,

Sameer Kumar | Database Consultant

ASHNIK PTE. LTD.

101 Cecil Street, #11-11 Tong Eng Building, Singapore 069533

This email may contain confidential, privileged or copyright material and is solely for the use of the intended recipient(s).

From: Ravi Kiran
Date: 11 January 2015, 17:53:11
Subject: Hash function

From: "Zelaznik, Steve"
Date: 13 January 2015, 17:19:12
Subject: Re: Convert boolean field to a 0 or a 1 in a select statement