pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedArray in plpgsql with composite type
2+ messages / 2 participants
[nested] [flat]
* Array in plpgsql with composite type
@ 2005-06-20 16:31 grupos <grupos@carvalhaes.net>
2005-06-20 23:36 ` Re: Array in plpgsql with composite type Michael Fuhr <mike@fuhr.org>
0 siblings, 1 reply; 2+ messages in thread
From: grupos @ 2005-06-20 16:31 UTC (permalink / raw)
To: pgsql-sql
Hi Guys!
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...
I searched a lot on the internet without success. On the PostgreSQL
manual there is no information how to handle array with plpgsql with
composite types. I tried to create a type (varchar, float8) but without
success...
Can anyone send me some examples or references for arrays in plpgsql (I
am using PostgreSQL 8.0.3).
Regards,
Rodrigo Carvalhaes
--
Esta mensagem foi verificada pelo sistema de antivírus e
acredita-se estar livre de perigo.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Array in plpgsql with composite type
2005-06-20 16:31 Array in plpgsql with composite type grupos <grupos@carvalhaes.net>
@ 2005-06-20 23:36 ` Michael Fuhr <mike@fuhr.org>
0 siblings, 0 replies; 2+ messages in thread
From: Michael Fuhr @ 2005-06-20 23:36 UTC (permalink / raw)
To: grupos <grupos@carvalhaes.net>; +Cc: 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/
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-06-20 23:36 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-06-20 16:31 Array in plpgsql with composite type grupos <grupos@carvalhaes.net>
2005-06-20 23:36 ` Michael Fuhr <mike@fuhr.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox