pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Which procedural language to use for functions.
2+ messages / 2 participants
[nested] [flat]

* Which procedural language to use for functions.
@ 2000-06-30 21:22  Saltsgaver, Scott <scottsa@aiinet.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Saltsgaver, Scott @ 2000-06-30 21:22 UTC (permalink / raw)
  To: pgsql-sql

Which procedural language is best for writing PostgreSQL functions:
'PL/pgSQL', 'PL/perl', or 'PL/Tcl'?  

I know that I can't do table creates in 'PL/pgSQL'?  

Is there an obvious choice as far speed and size?

Thanks,
Scott Saltsgaver
scottsa@aiinet.com



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Which procedural language to use for functions.
@ 2000-07-01 09:03  Jan Wieck <JanWieck@t-online.de>
  parent: Saltsgaver, Scott <scottsa@aiinet.com>
  0 siblings, 0 replies; 2+ messages in thread

From: JanWieck@t-online.de @ 2000-07-01 09:03 UTC (permalink / raw)
  To: Saltsgaver, Scott <scottsa@aiinet.com>; +Cc: pgsql-sql

Saltsgaver, Scott wrote:
> Which procedural language is best for writing PostgreSQL functions:
> 'PL/pgSQL', 'PL/perl', or 'PL/Tcl'?
>
> I know that I can't do table creates in 'PL/pgSQL'?
>
> Is there an obvious choice as far speed and size?

    PL/Tcl has the advantage that it can do the table creates you
    want.  OTOH if your frontend app is written in Perl, it's not
    that   likely   that   one  of  the  app  programmers  easily
    understands a function.

    I have no benchmarking  information  between  the  procedural
    languages.   If  that's really an issue, write your functions
    and triggers in C.


Jan

--

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





^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2000-07-01 09:03 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-06-30 21:22 Which procedural language to use for functions. Saltsgaver, Scott <scottsa@aiinet.com>
2000-07-01 09:03 ` Jan Wieck <JanWieck@t-online.de>

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