-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 >> Ragnar, Marc, thanks so much for the help: DISTINCT ON was *exactly* >> what I needed. >> It's not a part of any SQL standard I know of, but does the job >> _wonderfully_. > It's the single most useful non-standard SQL feature postgresql has. It > is thus simultaneously bad (from a portatbility aspect) and brilliant > (because it's a million times easier and faster than the alternatives). You mean second-most useful. LIMIT/OFFSET is the champion, hand down. :) - -- Greg Sabino Mullane greg@xxxxxxxxxxxx End Point http://www.endpoint.com/ PGP Key: 0x14964AC8 200612121616 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iD8DBQFFfxxjvJuQZxSWSsgRAokYAKDbmzEdfi3B/Fp0L62C6Fn48saMigCfeANo PFT+tLmygoaZpAqfDO241AQ= =n0xI -----END PGP SIGNATURE-----
