On Mon, May 09, 2005 at 07:05:18PM -0400, Bart Grantham wrote: > > Let me put it this way... how do I do this: > > -- my_array is an INT[] > > _my_array := select some_column from some_table; In PostgreSQL 7.4 and later you can use an array constructor: my_array := ARRAY(SELECT some_column FROM some_table); See "Array Constructors" in the "Value Expressions" section of the "SQL Syntax" chapter of the documentation: http://www.postgresql.org/docs/8.0/interactive/sql-expressions.html#SQL-SYNTAX-ARRAY-CONSTRUCTORS -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
