| From: | Randy Jonasz <rjonasz(at)click2net(dot)com> |
|---|---|
| To: | Nick Fankhauser <nickf(at)ontko(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | RE: SQL |
| Date: | 2000-11-08 17:01:19 |
| Message-ID: | Pine.BSF.4.21.0011081200580.27289-100000@nietzsche.jaded.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
That looks better! Thanks for your help
Cheers,
Randy
On Wed, 8 Nov 2000, Nick Fankhauser wrote:
>
> how about:
>
> SELECT banid FROM a WHERE flags NOT LIKE '%v%' AND banid NOT IN (SELECT
> banid FROM b);
>
> -Nick
>
> ----------------------------------------------------------------------------
> -----
> Nick Fankhauser
>
> Business: nickf(at)ontko(dot)com Phone 1.765.935.4283 Fax 1.765.962.9788
> Ray Ontko & Co. Software Consulting Services
> http://www.ontko.com/
>
> Personal: nickf(at)infocom(dot)com http://www.infocom.com/~nickf
>
>
>
Randy Jonasz
Software Engineer
Click2net Inc.
Web: http://www.click2net.com
Phone: (905) 271-3550
"You cannot possibly pay a philosopher what he's worth,
but try your best" -- Aristotle
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mickaël Jouanne | 2000-11-08 17:37:55 | VACUUM AND VACUUM ANALYSE |
| Previous Message | Nick Fankhauser | 2000-11-08 16:51:58 | RE: SQL |