subject:"\[HACKERS\] Disallow pullup of a subquery with a subquery in its targetlist\?"

Re: [HACKERS] Disallow pullup of a subquery with a subquery in its targetlist?

2013-11-07 Thread Tom Lane

I wrote: Back at http://www.postgresql.org/message-id/520d221e.2060...@gmail.com there was a complaint about strange behavior of a query that looks basically like this: SELECT ... FROM (SELECT ... , ( SELECT ... ORDER BY random() LIMIT

[HACKERS] Disallow pullup of a subquery with a subquery in its targetlist?

2013-11-05 Thread Tom Lane

Back at http://www.postgresql.org/message-id/520d221e.2060...@gmail.com there was a complaint about strange behavior of a query that looks basically like this: SELECT ... FROM (SELECT ... , ( SELECT ... ORDER BY random() LIMIT 1 )