Expressing a result set as an array (and vice versa)? - Mailing list pgsql-sql

From Don Maier
Subject Expressing a result set as an array (and vice versa)?
Date
Msg-id F3E0C44C-6118-41C6-AC71-2B19258F4F07@genome.stanford.edu
Whole thread Raw
Responses Re: Expressing a result set as an array (and vice versa)?
Re: Expressing a result set as an array (and vice versa)?
List 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




pgsql-sql by date:

Previous
From: Rod Taylor
Date:
Subject: Re: Find min and max values across two columns?
Next
From: Julie Robinson
Date:
Subject: SQL Query Newbie Help