Re: [GENERAL] SELECT based on function result

2004-07-18 Thread Edmund Bacon
Robert Fitzpatrick wrote: 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;

[GENERAL] SELECT based on function result

2004-07-15 Thread Robert Fitzpatrick
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

Re: [GENERAL] SELECT based on function result

2004-07-15 Thread David Parker
Fitzpatrick Sent: Thursday, July 15, 2004 4:31 PM To: PostgreSQL Subject: [GENERAL] SELECT based on function result 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