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
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 |