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.
Is there anyway to split a variable like the perl split above?
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.
Synaptic Vision Inc
Fax- (416) 539-8280
1179A King St. West
Suite 309 M6K 3C5
pgsql-sql by date
|Next:||From: Gerardo Castillo||Date: 2004-07-22 16:49:32|
|Subject: Problem with transaction in functions and tempory tables|
|Previous:||From: Chris Browne||Date: 2004-07-22 14:42:44|
|Subject: Re: LIKE on index not working|