--- Joe Conway <[EMAIL PROTECTED]> wrote: > 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;
PostgreSQL doesn't offer capturing parentheses. The regex library does offer that, but no-one has yet done the coding to bring that functionality into PostgreSQL. You could do it in two steps: 1. Test using a regular expression 2. locid := substr(r,1); table := substr(r,2,1-len(r)) (better check the syntax on those). > > 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 > > ---------------------------(end of > broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to > [EMAIL PROTECTED] > __________________________________ Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers! http://promotions.yahoo.com/new_mail ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings