Mike Nolan wrote:
>>Mike Nolan wrote:
>>
>>>>select * from foo('bar','debug')
>>>
>>>
>>>But how do I do that inside a pl/pgsql function?  'select into' doesn't
>>>seem to work properly.
>>
>>
>>You would have to code it. For example:
>>
>>IF $2 = ''debug'' THEN:
> 
> 
> That part I get, but I cannot seem to get an 'explain select....' to return
> the explain output inside a function.

Oh interesting. Hmmm. Alvaro can you think of a way to execute the 
result into a variable and return it as a notice?

Sincerely,

Joshua D. Drake


> --
> Mike Nolan


-- 
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedication Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/

In response to

• Re: Tuning queries inside a function at 2005-05-02 18:07:07 from Mike Nolan

Responses

• Re: Tuning queries inside a function at 2005-05-02 19:05:08 from Tom Lane

pgsql-general by date

Next:	From: Vlad	Date: 2005-05-02 18:51:30
	Subject: Re: [Dbdpg-general] Re: 'prepare' is not quite schema-safe
Previous:	From: Mike Nolan	Date: 2005-05-02 18:07:07
	Subject: Re: Tuning queries inside a function