On Tue, Apr 19, 2005 at 10:03:45AM -0600, Michael Fuhr wrote: > On Tue, Apr 19, 2005 at 11:17:46AM -0500, Don Isgitt wrote: > > > > Thanks, Tom. Interestingly enough, neither my original query or your > > corrected one returns anything with pg 7.4--another good reason to > > upgrade to 8.* > > Hmmm...for me both queries give the results shown if I run them in > 7.3.9, 7.4.7, 8.0.2, or 8.1devel. What's different about your 7.4 > installation? Maybe the regex_flavor setting? (not sure of the exact name) -- Alvaro Herrera (<alvherre[@]dcc.uchile.cl>) Maybe there's lots of data loss but the records of data loss are also lost. (Lincoln Yeoh) ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq