Re: [BUGS] BUG #5273: Unexpected function behavior/failure

2010-01-12 Thread Robert Haas
On Tue, Jan 12, 2010 at 7:45 PM, Tom Lane wrote: > "Vee" writes: >> -- The problem query >> select data, regexp_matches(data, '(h..l)') >> from test; > >>> hello        {hell} > >> Since I have no "where" clause, I would expect to see all the rows in the >> result of the second case, with possibl

Re: [BUGS] BUG #5273: Unexpected function behavior/failure

2010-01-12 Thread Tom Lane
"Vee" writes: > -- The problem query > select data, regexp_matches(data, '(h..l)') > from test; >> hello{hell} > Since I have no "where" clause, I would expect to see all the rows in the > result of the second case, with possibly a NULL value for the non-matched > rows. No. regexp_matc

[BUGS] BUG #5273: Unexpected function behavior/failure

2010-01-12 Thread Vee
The following bug has been logged online: Bug reference: 5273 Logged by: Vee Email address: se...@hotmail.com PostgreSQL version: 8.4.2 Operating system: Linux Description:Unexpected function behavior/failure Details: Hi, I have an odd problem using certain regular