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?
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
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|