Re: a question on SQL - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: a question on SQL
Date
Msg-id b2658024b71f33438c1e8e7544504b36@biglumber.com
Whole thread Raw
In response to Re: a question on SQL  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: a question on SQL  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
-----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@turnstep.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-----



pgsql-general by date:

Previous
From: "SunWuKung"
Date:
Subject: Re: search_path when restoring to new db
Next
From: "Jon Asher"
Date:
Subject: Postgres friendly RegEx?