SELECT based on function result

Поиск
Список
Период
Сортировка
От Robert Fitzpatrick
Тема SELECT based on function result
Дата
Msg-id 1089923438.5731.42.camel@columbus.webtent.org
обсуждение исходный текст
Ответы Re: SELECT based on function result
Список pgsql-general
I have a function that tells me if a record is positive and negative
based on several field values. I use it in select statements:

ohc=> SELECT sample_id, is_wipe_positive(tblleadwipe.sample_id) AS
positive FROM tblleadwipe WHERE hud_building_id IS NOT NULL;
 sample_id | positive
-----------+----------
        73 | f
        81 | t
(2 rows)

I see that I cannot change my WHERE statement to WHERE positive = 't'
because the column positive does not exist. Now I am looking for the
best way to return all records that are found positive or negative using
a query. Can anyone offer any guidance to how I can return all the
positives (or negatvies)? Or do I need to write another function that
does that?

--
Robert


В списке pgsql-general по дате отправления:

Предыдущее
От: "David Parker"
Дата:
Сообщение: moving an installation
Следующее
От: "David Parker"
Дата:
Сообщение: Re: SELECT based on function result