Re: [BUGS] BUG #14648: counts for queries using array unnesting is incorrect

"David G. Johnston" <david.g.johnston@gmail.com> writes:
> Yes, its intentional, and it isn't specific to just the unnest function so
> documenting it just there doesn't seem correct.  I don't know where it is
> documented but I suspect that even just reading the documentation for this
> would be of minimal help - I think its likely best learned after
> experiencing the aforementioned problem.

https://www.postgresql.org/docs/current/static/xfunc-sql.html#XFUNC-SQL-FUNCTIONS-RETURNING-SET

The last example in section 36.4.8 covers this specifically.

I've felt more than once that having these sorts of details about function
semantics underneath the "extending SQL" chapter isn't right, but I'm not
sure what organization would be better.  A lot of the examples would be
tough to do without use of custom-made functions.
        regards, tom lane


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs