2009/5/18 Gerardo Herzig <gherzig@fmed.uba.ar>:
> Dave Page wrote:
>> On Mon, May 18, 2009 at 1:29 PM, Gerardo Herzig <gherzig@fmed.uba.ar> wrote:
>>
>>> I think this is a good time to propose some kind of CookBook, to
>>> preserve this kind of answers.
>>
>> What, like this one?
>>
>> http://wiki.postgresql.org/wiki/Snippets
>>
>> :-)
>>
> Oops. Yeah, kind of :)
> Did not see any direct link from "Docs" main page.
>
>
this is usual tricks for arrays - you ca use it for min, max, avg,
sort for arrays. In 8.4 is possible to use generate_subscripts
functions.
regards
Pavel Stehule
others tricks http://www.postgres.cz/index.php/PostgreSQL_SQL_Tricks
regards
Pavel Stehule