Re: back references using regex

From: Matthew Peter <survivedsushi(at)yahoo(dot)com>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: back references using regex
Date: 2005-09-11 07:30:59
Message-ID: 20050911073059.7204.qmail@web35215.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

How about this then, I didn't retain that information
from the doc. ;) I sometimes glaze over important gems
every now and then. It happens. I'm not a robot, yet.
At least I know the answer to my question is now
retained. You were a big help too. Thank you very
much. I appreciate it.

Speaking of data manipulation in a table... I was
thinking about storing and manipulating a list in a
column...

Is it possible to append and delete (unknown location)
items in a list? Or is another way more efficient? I'm
relatively new so sorry if I'm asking too many
questions. If possible, I will read about it if
there's docs for it so I don't trouble anyone with my
questions. It would be sweet to do that at the
database level.

Thanks again,
MP
Posgresql convert

--- Michael Fuhr <mike(at)fuhr(dot)org> wrote:

> On Sat, Sep 10, 2005 at 10:27:13AM -0700, Matthew
> Peter wrote:
> > ahhhhhhhhh I swear I never came across any of
> these
> > gems of information in the docs. It was these
> subtle
> > differences that were throwing me.
>
> From "Regular Expression Escapes" in the "Pattern
> Matching" section
> of the manual:
>
> A back reference (\n) matches the same string
> matched by the
> previous parenthesized subexpression specified by
> the number n
> (see Table 9-18). For example, ([bc])\1 matches
> bb or cc but not
> bc or cb. The subexpression must entirely precede
> the back
> reference in the RE. Subexpressions are numbered
> in the order
> of their leading parentheses. Non-capturing
> parentheses do not
> define subexpressions.
>
>
http://www.postgresql.org/docs/8.0/static/functions-matching.html#POSIX-ESCAPE-SEQUENCES
>
> --
> Michael Fuhr
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please
> send an appropriate
> subscribe-nomail command to
> majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list
> cleanly
>



______________________________________________________
Yahoo! for Good
Watch the Hurricane Katrina Shelter From The Storm concert
http://advision.webevents.yahoo.com/shelter

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joost Kraaijeveld 2005-09-11 08:49:53 index and ilke question
Previous Message Mike Nolan 2005-09-11 05:55:26 Followup to week truncation thread