| From: | JanWieck(at)t-online(dot)de (Jan Wieck) |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Ian Turner <iant(at)mail(dot)brainstorm(dot)net>, Ian Turner <vectro(at)pipeline(dot)com>, pgsql-general(at)hub(dot)org |
| Subject: | Re: function language type? |
| Date: | 2000-07-26 19:31:12 |
| Message-ID: | 200007261931.VAA25037@hot.jw.home |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)Yahoo(dot)com #
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ulf Mehlig | 2000-07-26 19:46:31 | "alter table rename" does not update constraints |
| Previous Message | Jan Wieck | 2000-07-26 19:17:15 | Re: Some questions on user defined types and functions. |