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

Converting a plperlu function to a plpgsql function

From: Devin Whalen <devin(at)synapticvision(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Converting a plperlu function to a plpgsql function
Date: 2004-07-22 14:49:53
Message-ID: 1090507793.7474.27.camel@ (view raw, whole thread or download thread mbox)
Lists: pgsql-sql

I am trying to convert a database function that is written in perl to a 
PL/pgSQL function.  However, there a a couple of lines that I don't
think can be converted.

First line:
my @active_tables=split(/,/,$tables);

Is there anyway to split a variable like the perl split above?

Second line:

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

Is there any way to to regular expressions similar to above.  I need to
be able to save the matches for later use.  I know you can do regular
expressions in sql but I can't find any equivalent for the above.

Now you may be saying that why don't I just leave it in perl?  Well, I
would like to but my boss wants me to convert this to PL/pgSQL....long
story.  Anyway, if it can't be done it can't be done.  But I was just
wondering if anyone has any advice.

Thanks for the help.


Devin Whalen
Synaptic Vision Inc
Phone-(416) 539-0801
Fax- (416) 539-8280
1179A King St. West
Toronto, Ontario
Suite 309 M6K 3C5
Home-(416) 653-3982


pgsql-sql by date

Next:From: Gerardo CastilloDate: 2004-07-22 16:49:32
Subject: Problem with transaction in functions and tempory tables
Previous:From: Chris BrowneDate: 2004-07-22 14:42:44
Subject: Re: LIKE on index not working

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