Re: [GENERAL] postgres array quoting

2006-09-01 Thread Marc Evans
On Thu, 31 Aug 2006, [EMAIL PROTECTED] wrote: Hello - I am attempting to find a way to make use of arrays of text, as demonstraited by the following: CREATE TABLE messages ( id SERIAL, format TEXT NOT NULL, arguments TEXT[] ); Into that table will be values that you would associate with

Re: [GENERAL] postgres array quoting

2006-08-31 Thread Joshua D. Drake
Alvaro Herrera wrote: [EMAIL PROTECTED] wrote: Hello - I am attempting to find a way to make use of arrays of text, as demonstraited by the following: Interesting problem. Apparently plperl is not cool about parsing arrays in the arguments to Perl arrays -- at least I couldn't make it work,

Re: [GENERAL] postgres array quoting

2006-08-31 Thread Tom Lane
[EMAIL PROTECTED] writes: > * If I could figure a way to pass a variable number of arguments to a > plperl function, or an array reference, I could use something like this > function: Doesn't plperl already contain a feature to convert a Postgres array into a Perl array? It may be docum

Re: [GENERAL] postgres array quoting

2006-08-31 Thread Alvaro Herrera
[EMAIL PROTECTED] wrote: > Hello - > > I am attempting to find a way to make use of arrays of text, as > demonstraited by the following: Interesting problem. Apparently plperl is not cool about parsing arrays in the arguments to Perl arrays -- at least I couldn't make it work, and I don't find

[GENERAL] postgres array quoting

2006-08-31 Thread marc
Hello - I am attempting to find a way to make use of arrays of text, as demonstraited by the following: CREATE TABLE messages ( id SERIAL, format TEXT NOT NULL, arguments TEXT[] ); Into that table will be values that you would associate with some form of printf. For example: INSERT I