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@xxxxxxxx> 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@xxxxxxxxxxxxxx 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
