[Pgsql-ayuda] listar 1 a n columnas

Alvaro Herrera alvherre@dcc.uchile.cl
Wed, 3 Mar 2004 09:45:47 -0300


On Thu, Feb 12, 2004 at 02:38:31PM -0300, Armando Maldonado wrote:

> (select 1 as a) union (select 2 as a) union (select 3 as a) union (select 4 as 
> a) union (select 5 as a)

No conozco nada que haga eso en 7.4 o inferiores.  En la versión en
desarrollo hay una función pg_generate() que hace eso.

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
<Schwern> It does it in a really, really complicated way
<crab> why does it need to be complicated?
<Schwern> Because it's MakeMaker.