| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | grupos <grupos(at)carvalhaes(dot)net> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Array in plpgsql with composite type |
| Date: | 2005-06-20 23:36:44 |
| Message-ID: | 20050620233644.GA27951@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2005-06-21 00:12:40 | Re: SQL repr of bytea val |
| Previous Message | Din Adrian | 2005-06-20 20:49:36 | Re: UPDATEABLE VIEWS ... Examples? |