From: Rodrigo Gonzalez <rjgonzale@estrads.com.ar>
To: Robert Haas <robertmhaas@gmail.com>
Cc: CS DBA <cs_dba@consistentstate.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: function slower than the same code in an sql file
Date: Thu, 03 Nov 2011 12:31:59 -0300
Message-ID: <4EB2B3EF.60502@estrads.com.ar> (raw)
In-Reply-To: <CA+TgmoanpOaQS5112U2YBq0b81Ssoxs+MVi-3O+d9ftEKjL7pA@mail.gmail.com>
References: <4EAA3597.3020202@consistentstate.com>
<14399.1319778608@sss.pgh.pa.us>
<4EAAB09C.9060202@consistentstate.com>
<CA+TgmoanpOaQS5112U2YBq0b81Ssoxs+MVi-3O+d9ftEKjL7pA@mail.gmail.com>
El 03/11/11 11:42, Robert Haas escribió:
> On Fri, Oct 28, 2011 at 9:39 AM, CS DBA<cs_dba@consistentstate.com> wrote:
>> No parameters, one of them looks like this:
>>
>> [ code snippet ]
> It's hard to believe this is the real code, because SELECT without
> INTO will bomb out inside a PL/pgsql function, won't it?
>
But he's using CREATE TABLE xyz_view_m AS
So it seems correct to me
Regards
Rodrigo
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: rjgonzale@estrads.com.ar, robertmhaas@gmail.com, cs_dba@consistentstate.com, tgl@sss.pgh.pa.us
Subject: Re: function slower than the same code in an sql file
In-Reply-To: <4EB2B3EF.60502@estrads.com.ar>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox