On Sat, Jul 21, 2012 at 2:21 AM, Rich Shepard <rshepard@xxxxxxxxxxxxxxx> wrote: > On Sat, 21 Jul 2012, Chris Angelico wrote: > >> Try this: >> >> SELECT DISTINCT param FROM table WHERE indicator=0 >> EXCEPT >> SELECT DISTINCT param FROM table WHERE indicator=1 > > > Chris, > > Thank you. I knew it was simple, and I've not before used the EXCEPT > condition. > > Very much appreciate, > > Rich No probs! SQL, like many other languages, allows you to combine its primitives in some fairly complex ways. I don't know how hard it'd be to make it work on Postgres, but here's an epic piece of SQL awesomeness: http://thedailywtf.com/Articles/Stupid-Coding-Tricks-The-TSQL-Madlebrot.aspx ChrisA -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
