Re: Predicates not getting pushed into SQL function? - Mailing list pgsql-performance

From Jay Levitt
Subject Re: Predicates not getting pushed into SQL function?
Date
Msg-id 4EB83C5B.3020103@gmail.com
Whole thread Raw
In response to Re: Predicates not getting pushed into SQL function?  (Jay Levitt <jay.levitt@gmail.com>)
List pgsql-performance
Jay Levitt wrote:
> Yes, that patch works great! Oddly enough, the workaround now does NOT work;
> functions returning SETOF named composite types don't get inlined, but
> functions returning the equivalent TABLE do get inlined. Let me know if you
> need a failcase, but the bug doesn't actually affect me now :)

Never mind... I left a "strict" in my test.  Works great all around.

pgsql-performance by date:

Previous
From: Jay Levitt
Date:
Subject: Re: Predicates not getting pushed into SQL function?
Next
From: Claudio Freire
Date:
Subject: Re: Blocking excessively in FOR UPDATE