Re: SETOF / SETS_FIXED? - Mailing list pgsql-novice

From Tom Lane
Subject Re: SETOF / SETS_FIXED?
Date
Msg-id 26001.1012930486@sss.pgh.pa.us
Whole thread Raw
In response to SETOF / SETS_FIXED?  ("Joshua b. Jore" <josh@greentechnologist.org>)
Responses Re: SETOF / SETS_FIXED?  ("Joshua b. Jore" <josh@greentechnologist.org>)
List pgsql-novice
"Joshua b. Jore" <josh@greentechnologist.org> writes:
> While I was poking throug the source to figure this out I ran
> across the SETS_FIXED declaration. It looks like that's been set on my
> OpenBSD installation but isn't in the stock 7.1.3.

I would certainly hope that SETS_FIXED is NOT set in *any* distribution.
That covers some code we disabled years ago because it was broken;
I see little prospect that it will ever be resurrected.

The behavior you want is not a "set" in Berkeley's terminology,
anyway.  That had to do with fields (attributes) whose values were
actually references to functions to call to produce the implied
set-of-rows value.

AFAIR, the existing support for functions-returning-SETOF only works
for SQL-language functions, or suitably coded C functions.

            regards, tom lane

pgsql-novice by date:

Previous
From: "Joshua b. Jore"
Date:
Subject: SETOF / SETS_FIXED?
Next
From: "Patrick Hatcher"
Date:
Subject: user-defined not working