Re: [BUGS] BUG #4612: lc_numeric setting ignored

2009-01-13 Thread Mark Hayen
He Bruce, Thank you for replying. Does this mean that there is no way to do a "\copy from" using CSV files containing decimals with a comma? Mark Hayen ÿþDit bericht is vertrouwelijk en kan geheime informatie bevatten enkel

[BUGS] BUG #4613: intarray_del_elem returns an invalid empty array (for nullif comparison)

2009-01-13 Thread Valentine Gogichashvili
The following bug has been logged online: Bug reference: 4613 Logged by: Valentine Gogichashvili Email address: val...@gmail.com PostgreSQL version: 8.3.1 Operating system: Debian Linux (kernel 2.6.8) Description:intarray_del_elem returns an invalid empty array (for

Re: [BUGS] BUG #4613: intarray_del_elem returns an invalid empty array (for nullif comparison)

2009-01-13 Thread Tom Lane
"Valentine Gogichashvili" writes: > When contrib/intarray module - operation (intarray_del_elem) returns an > empty array, is not supposed to be empty This isn't really contrib/intarray's fault, it's a symptom of the general question of what an "empty" array is. See thread here: http://archives

[BUGS] problem with non-greedy regex match

2009-01-13 Thread Merlin Moncure
I _may_ have found a problem that is affecting non-greedy regex matches. select regexp_matches( $$x = foo y x = foo y $$, $$x\s+(.*?)y$$ ,'g'); As I read it, this should match ' = foo' twice. Instead, it matches "= foo y x = foo " once. The non-greedy form (.*?) should break out at the fir

Re: [BUGS] problem with non-greedy regex match

2009-01-13 Thread Tom Lane
"Merlin Moncure" writes: > I _may_ have found a problem that is affecting non-greedy regex matches. No, you didn't read the fine print in section 9.7.3.5; particularly A branch -- that is, an RE that has no top-level | operator -- has the same greediness as the first quantified atom in i

Re: [BUGS] BUG #4612: lc_numeric setting ignored

2009-01-13 Thread Bruce Momjian
Mark Hayen wrote: > He Bruce, > > Thank you for replying. > Does this mean that there is no way to do a "\copy from" using CSV files > containing decimals with > a comma? That is correct, sorry. -- Bruce Momjian http://momjian.us EnterpriseDB http://ente