| From: | <operationsengineer1(at)yahoo(dot)com> |
|---|---|
| To: | operationsengineer1(at)yahoo(dot)com, "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: How To Exclude True Values |
| Date: | 2006-06-06 02:07:14 |
| Message-ID: | 20060606020714.61758.qmail@web33304.mail.mud.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
> hi all,
>
> how can i exclude true values for this query?
>
> http://www.rafb.net/paste/results/obtkGz26.html
>
> if i uncomment out
>
> -- AND t_inspect_result.inspect_result_pass = 'f'
>
> it looks for prior falses within an inspect_id and
> returns it. i want the original result set minus
> the
> trues, if possible.
>
> tia...
this SQL appears to do the trick...
http://www.rafb.net/paste/results/zZKIjH80.html
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | operationsengineer1 | 2006-06-06 02:24:25 | Re: How To Exclude True Values |
| Previous Message | operationsengineer1 | 2006-06-06 00:17:58 | How To Exclude True Values |