From: Gurudutt <guru@indvalley.com>
To: pgsql-sql@postgresql.org
Subject: Re: Resources - Regular Expressions
Date: Tue, 15 Jan 2002 10:15:40 +0530
Message-ID: <732297387.20020115101540@indvalley.com> (raw)
In-Reply-To: <3.0.6.32.20020111161313.007a2310@pop6.sympatico.ca>
References: <3.0.6.32.20020111141809.021c4eb0@pop6.sympatico.ca>
<NEBBLAAHGLEEPCGOBHDGEEOKECAA.nickf@ontko.com>
<3.0.6.32.20020111141809.021c4eb0@pop6.sympatico.ca>
<3.0.6.32.20020111161313.007a2310@pop6.sympatico.ca>
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@indvalley.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:
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: guru@indvalley.com
Subject: Re: Resources - Regular Expressions
In-Reply-To: <732297387.20020115101540@indvalley.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox