Re: back references using regex - Mailing list pgsql-general

From Matthew Peter
Subject Re: back references using regex
Date
Msg-id 20050911073059.7204.qmail@web35215.mail.mud.yahoo.com
Whole thread Raw
In response to Re: back references using regex  (Michael Fuhr <mike@fuhr.org>)
Responses Re: back references using regex
List 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@fuhr.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@postgresql.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


pgsql-general by date:

Previous
From: Mike Nolan
Date:
Subject: Followup to week truncation thread
Next
From: "Sim Zacks"
Date:
Subject: pg_autovacuum not doing anything