On Tue, Dec 12, 2006 at 06:29:07PM +0000, Tomi N/A wrote: > 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). Have a nice day, -- Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to litigate.
Attachment:
signature.asc
Description: Digital signature
