Re: Convert boolean field to a 0 or a 1 in a select statement

Поиск

Список

Период

Сортировка

От	Zelaznik, Steve
Тема	Re: Convert boolean field to a 0 or a 1 in a select statement
Дата	13 января 2015 г. 17:19:12
Msg-id	77CAECB87E4C6748A77C194E6D8F6B9626146338@crexhtmail04.us.aegon.com обсуждение исходный текст
Ответ на	Re: Convert boolean field to a 0 or a 1 in a select statement (Sameer Kumar <sameer.kumar@ashnik.com>)
Ответы	Re: Convert boolean field to a 0 or a 1 in a select statement
Список	pgsql-novice

Дерево обсуждения

I’m more explicit with my CASE statements, explicitly putting the equals sign in place. Such as in the attachment “explicit_equals.gif”. I’m not sure how your CASE statement works, but generally you can only omit the equals sign when you’re dealing with a pure Boolean value, such as the other attachment “pure_ bool.gif”.

-Steve Z

From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Sameer Kumar
Sent: Monday, January 12, 2015 1:31 AM
To: JORGE MALDONADO
Cc: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] Convert boolean field to a 0 or a 1 in a select statement

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