Hello, 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. Later -- Devin Whalen Programmer 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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html