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: (view raw or whole thread)
Lists: pgsql-novice

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).


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-2015 The PostgreSQL Global Development Group