Expressing a result set as an array (and vice versa)?

From: Don Maier <dMaier(at)genome(dot)stanford(dot)edu>
To: pgsql-sql(at)postgresql(dot)org
Subject: Expressing a result set as an array (and vice versa)?
Date: 2006-03-23 19:44:32
Message-ID: F3E0C44C-6118-41C6-AC71-2B19258F4F07@genome.stanford.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Good day,

Is it possible to construct an array from an appropriate select
expression that generates a result set of unknown cardinality?
To focus on the simple case: Is it possible to construct a one-
dimensional array from a select of a single column in a table with an
unknown number of rows?

Conversely, is it possible to construct a (single column) result set
from a select expression on a one-dimensional array with an unknown
number of elements?

Thanks for any hints!

Regards,
Don Maier

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jim C. Nasby 2006-03-24 13:21:44 Nightly builds (was: [SQL] Function Parameters in GROUP BY clause cause errors)
Previous Message Daniel Caune 2006-03-23 19:20:26 Re: OUT parameter