Re: Does it make sense to break a large query into separate functions?

Thanks Tom,
I am happy with a 10K feet level discussion of the approach, and your
response is just what I was looking for.

Regards
Seref

On Wed, May 8, 2013 at 3:05 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Seref Arikan <serefarikan(at)kurumsalteknoloji(dot)com> writes:
> > I've just noticed that some parts of the autogenerated queries can be
> > functions on their own. Would moving these parts to their own functions
> > help the query planner?
>
> It's difficult to answer that without a lot more detail than you've
> provided, but my offhand guess would be "no". Usually it's better
> when the planner can expand functions inline, which would just be
> reversing the transformation you're thinking of.
>
> regards, tom lane
>