From: Josh Berkus <josh@agliodbs.com>
To: Joe Conway <mail@joeconway.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Which is faster SQL or PL/PGSQL
Date: Mon, 20 Oct 2003 12:00:31 -0700
Message-ID: <200310201200.31857.josh@agliodbs.com> (raw)
In-Reply-To: <3F942F72.6050709@joeconway.com>
References: <Pine.LNX.4.44.0310201119240.10378-100000@server1.techplant.com>
<200310201124.02090.josh@agliodbs.com>
<3F942F72.6050709@joeconway.com>
Joe,
> Never tried it, but is it possible to use a prepared statement inside a
> PL/pgSQL function? In any case, you can in other PLs. And with library
> preloading (starting in 7.4), the first call to other PLs is similar to
> that of PL/pgSQL. See:
> http://archives.postgresql.org/pgsql-patches/2003-07/msg00239.php
Not sure how useful it would be in my case; I'm using EXECUTE because I'm
building a dynamic query based on user input, so the query plans would need
to vary radically from run to run.
--
-Josh Berkus
Aglio Database Solutions
San Francisco
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-sql@postgresql.org
Cc: josh@agliodbs.com, mail@joeconway.com
Subject: Re: Which is faster SQL or PL/PGSQL
In-Reply-To: <200310201200.31857.josh@agliodbs.com>
* 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