Re: a question on SQL

-----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(at)turnstep(dot)com
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-----