> it looks like row_number is evaluated before SRF - this behave is > absolutely undefined - for me - more native behave is different evaluation.
SRFs which return multiple rows in the SELECT clause have ALWAYS behaved oddly when it comes to row evaluation (LIMIT, COUNT(), etc.). This isn't necessarily desireable, but it is consistent with past releases, and it's not in any way limited to Windowing functions. In general, if you care about rows when calling such an SRF, you need to subselect it. It would be nice to clean that up, but you'd have to start with a comprehensive definition of what the behavior *should* be in all common cases. And then you'd be in for a big code overhaul. -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgsql-hackers mailing list (email@example.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers