Re: concat_ws

"Tom Lane"  wrote:
> Joe Conway  writes:
> > Tom Lane wrote:
> >> It seems to be running out of memory.
> 
> > Also worth noting, without STRICT, even a plain EXPLAIN *without* 
> > ANALYZE causes the problem to show itself.
> 
> Yeah.  The problem is that the SQL function inliner generates an
> enormous expression tree from this function definition.  7.3 had no
> inliner so no problem.
> 
> I am not sure what to do about it --- the only idea that comes to mind
> is to put an arbitrary limit (of, say, 5 or 10 function calls) on the
> depth of inlining expansion.  That seems like a pretty ugly answer
> ... anyone have a better one?

Please no one tell to add another ugly parameter on postgresql.conf

My cent.

Regards
Gaetano Mendola