Re: function language type? - Mailing list pgsql-general

From JanWieck@t-online.de (Jan Wieck)
Subject Re: function language type?
Date
Msg-id 200007261931.VAA25037@hot.jw.home
Whole thread Raw
In response to Re: function language type?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane wrote:
>
> > Can one create tables using the perl, C, or TCL interfaces?
>
> Offhand I think this would work out-of-the-box in pltcl and plperl,
> because they don't do preplanning.  This is also why you can do
> something like "SELECT ... FROM $1" in those PLs and not in plpgsql:
> they just form the command as a string and then run it through the
> whole parse/plan process every time.

    More  than  that.  PL/Tcl  supports  saved  plans,  but  also
    supports direct SPI query execution. So it's the decision  of
    the  function programmer, which queries to plan and save once
    and which don't.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



pgsql-general by date:

Previous
From: "Joel Burton"
Date:
Subject: PostgreSQL + Microsoft Access FAQ Draft Announcement
Next
From: JanWieck@t-online.de (Jan Wieck)
Date:
Subject: Re: Some questions on user defined types and functions.