From 0e461f275b9a69e28fd62ab15a6ec5e8bb61ff7a Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Sun, 18 Feb 2007 01:32:55 +0000 Subject: [PATCH] Add: * Allow SQL-language functions to reference parameters by parameter name Currently SQL-language functions can only refer to parameters via $1, etc --- doc/TODO | 6 +++++- doc/src/FAQ/TODO.html | 5 ++++- 2 files changed, 9 insertions(+), 2 deletions(-) diff --git a/doc/TODO b/doc/TODO index c922167286..2cbd7987cc 100644 --- a/doc/TODO +++ b/doc/TODO @@ -2,7 +2,7 @@ PostgreSQL TODO List ==================== Current maintainer: Bruce Momjian (bruce@momjian.us) -Last updated: Fri Feb 16 21:00:55 EST 2007 +Last updated: Sat Feb 17 20:32:39 EST 2007 The most recent version of this document can be viewed at http://www.postgresql.org/docs/faqs.TODO.html. @@ -367,6 +367,10 @@ Functions http://archives.postgresql.org/pgsql-hackers/2006-10/msg00665.php +* Allow SQL-language functions to reference parameters by parameter name + + Currently, SQL-language functions can only refer to parameters via $1, etc + * Add SPI_gettypmod() to return the typemod for a TupleDesc * Enforce typmod for function inputs, function results and parameters for spi_prepare'd statements called from PLs diff --git a/doc/src/FAQ/TODO.html b/doc/src/FAQ/TODO.html index 07f3f93da1..c88d1e4132 100644 --- a/doc/src/FAQ/TODO.html +++ b/doc/src/FAQ/TODO.html @@ -8,7 +8,7 @@

PostgreSQL TODO List

Current maintainer: Bruce Momjian (bruce@momjian.us)
-Last updated: Fri Feb 16 21:00:55 EST 2007 +Last updated: Sat Feb 17 20:32:39 EST 2007

The most recent version of this document can be viewed at
http://www.postgresql.org/docs/faqs.TODO.html. @@ -335,6 +335,9 @@ first. There is also a developer's wiki at

  • Implement inlining of set-returning functions defined in SQL
  • Allow SQL-language functions to return results from RETURNING queries

    http://archives.postgresql.org/pgsql-hackers/2006-10/msg00665.php +

    +
  • Allow SQL-language functions to reference parameters by parameter name +

    Currently, SQL-language functions can only refer to parameters via $1, etc

  • Add SPI_gettypmod() to return the typemod for a TupleDesc
  • Enforce typmod for function inputs, function results and parameters for -- 2.40.0