From f99e525f0f0644522c0e93cb72297acd69963cf6 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Thu, 17 Oct 2002 23:34:10 +0000 Subject: [PATCH] Update for tables returning function, item 5.3, from Joe Conway. --- doc/FAQ | 9 ++++++--- doc/src/FAQ/FAQ.html | 9 ++++++--- 2 files changed, 12 insertions(+), 6 deletions(-) diff --git a/doc/FAQ b/doc/FAQ index 56d907042d..0a11568350 100644 --- a/doc/FAQ +++ b/doc/FAQ @@ -1,7 +1,7 @@ Frequently Asked Questions (FAQ) for PostgreSQL - Last updated: Sun Oct 13 23:15:09 EDT 2002 + Last updated: Thu Oct 17 19:33:40 EDT 2002 Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) @@ -1113,8 +1113,11 @@ CREATE TABLE test (x int, modtime timestamp DEFAULT CURRENT_TIMESTAMP ); 5.3) How do I write a C function to return a tuple? - This requires wizardry so extreme that the authors have never tried - it, though in principle it can be done. + In versions of PostgreSQL beginning with 7.3, table-returning + functions are fully supported in C, PL/PgSQL, and SQL. See the + Programmer's Guide for more information. An example of a + table-returning function defined in C can be found in + contrib/tablefunc. 5.4) I have changed a source file. Why does the recompile not see the change? diff --git a/doc/src/FAQ/FAQ.html b/doc/src/FAQ/FAQ.html index b8b24ccae0..879e907214 100644 --- a/doc/src/FAQ/FAQ.html +++ b/doc/src/FAQ/FAQ.html @@ -14,7 +14,7 @@ alink="#0000ff">

Frequently Asked Questions (FAQ) for PostgreSQL

-

Last updated: Sun Oct 13 23:15:09 EDT 2002

+

Last updated: Thu Oct 17 19:33:40 EDT 2002

Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)
@@ -1408,8 +1408,11 @@ BYTEA bytea variable-length byte array (null-byte safe)

5.3) How do I write a C function to return a tuple?

-

This requires wizardry so extreme that the authors have never - tried it, though in principle it can be done.

+

In versions of PostgreSQL beginning with 7.3, table-returning + functions are fully supported in C, PL/PgSQL, and SQL. See the + Programmer's Guide for more information. An example of a + table-returning function defined in C can be found in + contrib/tablefunc.

5.4) I have changed a source file. Why does the recompile not see the change?

-- 2.40.0