Received: from web20802.mail.yahoo.com (web20802.mail.yahoo.com [216.136.226.191]) by postgresql.org (8.11.3/8.11.4) with SMTP id g0FF3cV62402 for ; Tue, 15 Jan 2002 10:03:38 -0500 (EST) (envelope-from jeff_eckermann@yahoo.com) Message-ID: <20020115150341.60681.qmail@web20802.mail.yahoo.com> Received: from [65.11.165.34] by web20802.mail.yahoo.com via HTTP; Tue, 15 Jan 2002 07:03:41 PST Date: Tue, 15 Jan 2002 07:03:41 -0800 (PST) From: Jeff Eckermann Subject: Re: Resources - Regular Expressions To: "Guru\(External\)" , pgsql-sql@postgresql.org In-Reply-To: <732297387.20020115101540@indvalley.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200201/166 X-Sequence-Number: 6252 Not implemented in PostgreSQL RE's AFAIK. But you can use pl/perl to do it. Just write a function that takes a text type parameter (your RE string) and returns the $1 value. --- Gurudutt wrote: > 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 fro 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: > > > ---------------------------(end of > broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please > send an appropriate > subscribe-nomail command to majordomo@postgresql.org > so that your > message can get through to the mailing list cleanly __________________________________________________ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/