Re: Tuning queries inside a function

From: Mike Nolan <nolan(at)gw(dot)tssi(dot)com>
To: jd(at)commandprompt(dot)com (Joshua D(dot) Drake)
Cc: alvherre(at)dcc(dot)uchile(dot)cl (Alvaro Herrera), pgsql-general(at)postgresql(dot)org (pgsql general list)
Subject: Re: Tuning queries inside a function
Date: 2005-05-02 18:07:07
Message-ID: 200505021807.j42I78oB001616@gw.tssi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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.
--
Mike Nolan

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2005-05-02 18:27:27 Re: Tuning queries inside a function
Previous Message Marko Kreen 2005-05-02 17:54:14 Re: Using pgcrypto with AES-256 bits?