Conditional on Select List
| От | Fernando |
|---|---|
| Тема | Conditional on Select List |
| Дата | |
| Msg-id | 4829B938.1060805@ggtours.ca обсуждение исходный текст |
| Ответы |
Re: Conditional on Select List
Re: Conditional on Select List Re: Conditional on Select List Re: Conditional on Select List Re: Conditional on Select List Re: Conditional on Select List Re: Conditional on Select List |
| Список | pgsql-general |
Is it possible to do this?
SELECT IF(COUNT(colname) > 0, TRUE, FALSE) AS colname FROM table;
What I want is to return a boolean, but when I tried SELECT COUNT(colname)::BOOLEAN FROM table; it says it cannot cast bigint to boolean.
Is there such IF function or do I have to create my own.
Thank you.
SELECT IF(COUNT(colname) > 0, TRUE, FALSE) AS colname FROM table;
What I want is to return a boolean, but when I tried SELECT COUNT(colname)::BOOLEAN FROM table; it says it cannot cast bigint to boolean.
Is there such IF function or do I have to create my own.
Thank you.
В списке pgsql-general по дате отправления: