Re: Important speed difference between a query and a

From: Frederic Jolliton <fred-pg(at)jolliton(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Important speed difference between a query and a
Date: 2003-04-24 17:40:17
Message-ID: 863ck7ssji.fsf@mau.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> On Thu, 24 Apr 2003, Frederic Jolliton wrote:
[...]
>> The server is rather fast, and the query return 10 to 50 rows in
>> most case. So, this is probably a solution, even if it's not very
>> clean. (Well, I have to find an example to RETURN the result of
>> EXECUTE..)

Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> writes:
> Check out
> http://techdocs.postgresql.org/guides/SetReturningFunctions
>
> specifically the GetRows() function for an example of using for in
> execute with set returning functions.

Oh right. Thanks you for pointing out this.

--
Frédéric Jolliton

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jim C. Nasby 2003-04-24 23:38:17 More tablescanning fun
Previous Message Stephan Szabo 2003-04-24 17:28:08 Re: Important speed difference between a query and a