Re: Array in plpgsql with composite type - Mailing list pgsql-sql

From Michael Fuhr
Subject Re: Array in plpgsql with composite type
Date
Msg-id 20050620233644.GA27951@winnie.fuhr.org
Whole thread Raw
In response to Array in plpgsql with composite type  (grupos <grupos@carvalhaes.net>)
List pgsql-sql
On Mon, Jun 20, 2005 at 01:31:20PM -0300, grupos wrote:
> 
> I need to make an array with composite type (varchar, float8) to get 
> data from a table (description and price) BUT I am having no success... 

According to the "Arrays" section of the "Data Types" chapter in
the documentation, arrays of composite types aren't supported.

http://www.postgresql.org/docs/8.0/static/arrays.html

What problem are you trying to solve?  If you tell us more about
what you're doing then maybe we can suggest ways to do it.  One way
might be to use a procedural language like PL/Perl, PL/Tcl, or
PL/Python instead of PL/pgSQL.

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/


pgsql-sql by date:

Previous
From: grupos
Date:
Subject: Array in plpgsql with composite type
Next
From: Michael Fuhr
Date:
Subject: Re: SQL repr of bytea val