Postgres Pro
Downloads
Home   >   mailing lists

Re: Generating table rows from arrays - Mailing list pgsql-sql

From Florian Weimer
Subject Re: Generating table rows from arrays
Date
Msg-id 82sku8buqv.fsf@mid.bfk.de
Whole thread Raw
In response to Re: Generating table rows from arrays  (Richard Huxton <dev@archonet.com>)
List pgsql-sql
Tree view 
* Richard Huxton:

>> The first row is constant.  I could write a loop with PL/pgsql, I
>> guess, but I wonder if there are better options nowadays.
>
> The smallest function I've seen is Merlin Moncure's here:
>
> http://people.planetpostgresql.org/merlin/index.php?/archives/4-fun-with-arrays.html


Ah, neat trick.  Thanks.

--
Florian Weimer                <fweimer@bfk.de>
BFK edv-consulting GmbH       http://www.bfk.de/
Kriegsstraße 100              tel: +49-721-96201-1
D-76133 Karlsruhe             fax: +49-721-96201-99

pgsql-sql by date:

Previous
From: "Oliveiros Cristina"
Date:
Subject: Re: How to GROUP results BY month
Next
From: Alvaro Herrera
Date:
Subject: Re: pg_advisory_lock(bigint) vs. LOCK TABLE