Re: arrays, composite types - Mailing list pgsql-general

From Greg Stark
Subject Re: arrays, composite types
Date
Msg-id 87br2z4m9w.fsf@stark.xeocode.com
Whole thread Raw
In response to arrays, composite types  (Roman Neuhauser <neuhauser@sigpipe.cz>)
Responses Re: arrays, composite types
List pgsql-general
Roman Neuhauser <neuhauser@sigpipe.cz> writes:

> I'm looking for an equivalent of my_composite_type[] for use as a
> parameter of a pl/pgsql function. What do people use to dodge this
> limitation?
>
> Background: I have a few plpgsql functions that basically accept an
> array of objects decomposed into arrays of the objects' attributes:

What do you want to do with these arrays? Why do you want to work with them in
plpgsql?

When you get to this point I think I would start looking at using plperl and
using Dumper to store the objects in a text column. You're trading off
database normalization against being able to express arbitrarily complex data
structures.

--
greg

pgsql-general by date:

Previous
From: Alex
Date:
Subject: Function to test for Valid Date
Next
From: Andreas Kretschmer
Date:
Subject: Re: Function to test for Valid Date