From: | Gurudutt <guru(at)indvalley(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Resources - Regular Expressions |
Date: | 2002-01-15 04:45:40 |
Message-ID: | 732297387.20020115101540@indvalley.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi!!
Thanks a lot for all the advices, I knew i could always get help from
the lists. Had festival so couldn't reply earlier and we were closed.
I have parallel question, I read about regular expressions being
faster than the 'like', is it correct and one more thing how do u
extract information from a given regular expression
eg: like in perl anything inside the () can be extracted into a
variable
like...
# Program Segment Starts here
$disksize = $1 if (/Storage Swap size:\s+([-0-9\.]+)\s+MB/);
# Program segment ends here
as u can see the '$1' has the value of the expression thats got evaluated.
Now my question is when i use the same in a SQL statement all I can
get is just a boolean value whether it evaluates to true or false ,
nothing more than that.
I would like to extract the value from the evaluated regular
expression in a SQL query
Is that possible?
Thanks in advance...
Best regards,
Gurudutt mailto:guru(at)indvalley(dot)com
Life is not fair - get used to it.
Bill Gates
Saturday, January 12, 2002, 2:43:13 AM, you wrote:
FB> At 03:42 PM 1/11/02 -0500, Wei Weng wrote:
From | Date | Subject | |
---|---|---|---|
Next Message | Roberto Mello | 2002-01-15 06:29:33 | Re: On delete cascade! |
Previous Message | Chester Carlton Young | 2002-01-15 02:04:15 | Re: Long-running DELETE...WHERE... |