Re: Converting a plperlu function to a plpgsql function - Mailing list pgsql-sql

Devin Whalen wrote:
> First line:
> my @active_tables=split(/,/,$tables);
> 
> Is there anyway to split a variable like the perl split above?

I'm no perl guru, but in 7.4 I believe this does what you're looking for:

regression=# select string_to_array('1,2,3',','); string_to_array
----------------- {1,2,3}
(1 row)

> Second line:
> 
>  if ($r=~/^-([0-9]?)([A-z_]+)/)
>  {
>     my $locid = $1;
>     my $table = $2;

Not sure about this one. Hopefully someone else can chime in. Maybe a 
little less efficient, but it seems like it would be easy enough to 
parse when true.

HTH,

Joe