Postgres Pro
Downloads
Home   >   mailing lists

Re: function call vs staright query - Mailing list pgsql-performance

From Tom Lane
Subject Re: function call vs staright query
Date
Msg-id 21145.1174277261@sss.pgh.pa.us
Whole thread Raw
In response to Re: function call vs staright query  (Vincenzo Romano <vincenzo.romano@gmail.com>)
Responses Re: function call vs staright query  (Vincenzo Romano <vincenzo.romano@gmail.com>)
List pgsql-performance
Tree view 
Vincenzo Romano <vincenzo.romano@gmail.com> writes:
> How can I delay the query planner decisions until the actual query is to be
> done inside the function body?

Use plpgsql's EXECUTE.  AFAIR there is no way in a SQL-language function.

            regards, tom lane

pgsql-performance by date:

Previous
From: Michael Stone
Date:
Subject: Re: Performance Tuning and Disk Cache
Next
From: Vincenzo Romano
Date:
Subject: Re: function call vs staright query