Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Re: Re: regexp_matches illegally restricts rows -- just a documentation issue?
On Tue, Apr 6, 2010 at 1:06 AM, Josh Berkus <josh(at)postgresql(dot)org> wrote: > On 4/5/10 9:16 PM, Josh Berkus wrote: > >> I can't see how this is anything but a bug; as far as I know, nothing in >> the target list is allowed to restrict the number of rows which are >> returned by the query. We should get 7 rows, 3 of which have an empty >> array or a NULL in the 2nd column. > > Just noticed it's a SETOF[] function. Which makes it odd that I can > call it in the target list at all, but explains the row restriction. > > It's still confusing behavior (three regulars on IRC thought it was a > bug too) and users should be warned in the documentation. Not sure > exactly where, though ... maybe in 9.7? While I understand why this is confusing, it's really very normal behavior for a SRF, and I don't really think it makes sense to document that this SRF behaves just like other SRFs... ...Robert
In response to
- Re: regexp_matches illegally restricts rows -- just a documentation issue? at 2010-04-06 05:06:46 from Josh Berkus
Responses
- Re: Re: regexp_matches illegally restricts rows -- just a documentation issue? at 2010-04-06 19:42:12 from Josh Berkus
pgsql-bugs by date
Next: From: Magnus Hagander Date: 2010-04-06 17:39:56 Subject: Re: BUG #5394: invalid declspec for PG_MODULE_MAGIC Previous: From: Josh Berkus Date: 2010-04-06 05:06:46 Subject: Re: regexp_matches illegally restricts rows -- just a documentation issue?