From: Pavel Stehule <pavel.stehule@gmail.com>
To: Gerardo Herzig <gherzig@fmed.uba.ar>
Cc: Dave Page <dpage@pgadmin.org>
Cc: postgres list <pgsql-sql@postgresql.org>
Subject: Re: proposal for a CookBook in postgresql.org
Date: Mon, 18 May 2009 14:34:51 +0200
Message-ID: <162867790905180534h5a53df39r1cd1ce7cada091f3@mail.gmail.com> (raw)
In-Reply-To: <4A115CFA.9080906@fmed.uba.ar>
References: <4A1154A5.80608@fmed.uba.ar>
<937d27e10905180457u32399574o9413511deaf69eee@mail.gmail.com>
<4A115CFA.9080906@fmed.uba.ar>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: pavel.stehule@gmail.com, gherzig@fmed.uba.ar, dpage@pgadmin.org
Subject: Re: proposal for a CookBook in postgresql.org
In-Reply-To: <162867790905180534h5a53df39r1cd1ce7cada091f3@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox