pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jeff Eckermann <jeff_eckermann@yahoo.com>
To: Guru\(External\) <guru@indvalley.com>
To: pgsql-sql@postgresql.org
Subject: Re: Resources - Regular Expressions
Date: Tue, 15 Jan 2002 07:03:41 -0800 (PST)
Message-ID: <20020115150341.60681.qmail@web20802.mail.yahoo.com> (raw)
In-Reply-To: <732297387.20020115101540@indvalley.com>

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 <guru@indvalley.com> 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/



view thread (2+ messages)

Message-ID: <20020115150341.60681.qmail@web20802.mail.yahoo.com>
Permalink:  ../20020115150341.60681.qmail@web20802.mail.yahoo.com/
Also on:    postgresql.org/message-id/20020115150341.60681.qmail@web20802.mail.yahoo.com

 · 

reply

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: jeff_eckermann@yahoo.com, guru@indvalley.com
  Subject: Re: Resources - Regular Expressions
  In-Reply-To: <20020115150341.60681.qmail@web20802.mail.yahoo.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