From: | Robert Fitzpatrick <robert(at)webtent(dot)com> |
---|---|
To: | PostgreSQL <pgsql-general(at)postgresql(dot)org> |
Subject: | SELECT based on function result |
Date: | 2004-07-15 20:30:38 |
Message-ID: | 1089923438.5731.42.camel@columbus.webtent.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | David Parker | 2004-07-15 20:37:04 | Re: SELECT based on function result |
Previous Message | David Parker | 2004-07-15 20:05:20 | moving an installation |