Re: [SQL] 16 parameter limit

From: Jan Wieck <JanWieck(at)Yahoo(dot)com>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: John Proctor <jproctor(at)prium(dot)net>, Neil Conway <nconway(at)klamath(dot)dyndns(dot)org>, josh(at)agliodbs(dot)com, peter_e(at)gmx(dot)net, tgl(at)sss(dot)pgh(dot)pa(dot)us, pgsql-patches(at)postgresql(dot)org
Subject: Re: [SQL] 16 parameter limit
Date: 2002-08-14 18:30:53
Message-ID: 3D5AA1DD.B4F6D946@Yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches pgsql-sql

Bruce Momjian wrote:
>
> Added to TODO:
>
> o Improve PL/PgSQL exception handling

Exception handling? You're talking about nested transaction support and
catchable errors in the first place, and then (a year later) making use
of that functionality in the procedural languages, right?

> o Allow PL/PgSQL parameters to be specified by name and type during
> definition
> o Allow PL/PgSQL function parameters to be passed by name,
> get_employee_salary(emp_id => 12345, tax_year => 2001)

CREATE FUNCTION is in no way PL/pgSQL specific. PL/pgSQL simply works
around that lack with the ALIAS syntax in the DECLARE section.

> o Add PL/PgSQL packages

This really is a 100% PL/PgSQL problem.

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 #

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-08-14 18:34:38 Re: Open 7.3 items
Previous Message Bruce Momjian 2002-08-14 18:24:50 Re: Open 7.3 items

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2002-08-14 18:34:40 Re: [SQL] 16 parameter limit
Previous Message Tom Lane 2002-08-14 18:15:46 Re: Documentation update (pg_get_fkeydef, current_database)

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 2002-08-14 18:34:40 Re: [SQL] 16 parameter limit
Previous Message Tom Lane 2002-08-14 17:25:14 Re: sql function examples requested (! select)