Skip site navigation (1) Skip section navigation (2)

array values and pl/perl(poss. repost)

From: "Morgan Kita" <mkita(at)verseon(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: array values and pl/perl(poss. repost)
Date: 2005-07-27 21:16:37
Message-ID: 08B420FF5BF7BC42A064212C2EB7688017E4F2@neutron.verseon.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi,

I had a simple question about pl/perl. I am writing a function that takes a row from a table as input which has an attribute that is a text[][] array.
How do I best parse this array attribute inside the body of the pl/perl function? Is there anything built into pl/perl to allow me to automatically convert the postgres style array to a perl array, so that I can cleanly iterate through the elements? If not is my only option to write a text parser for this?(Seems like too much club to me).

Thanks,
Morgan

pgsql-novice by date

Next:From: Jeff EckermannDate: 2005-07-27 23:53:49
Subject: Re: Troubles with PL/Perl in PgSQL
Previous:From: Mogin MohandasDate: 2005-07-27 20:49:04
Subject: compiling

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group