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

From Joshua b. Jore
Subject Re: SETOF / SETS_FIXED?
Date
Msg-id Pine.BSO.4.40.0202070701150.16805-100000@kitten.greentechnologist.org
Whole thread Raw
In response to Re: SETOF / SETS_FIXED?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Ah, then I've been misled. I grepped my source and SETS_FIXED is never
defined. If you read the source and some of the (hard to find) docs
regarding the SETOF operator you run into comments like "this probably
doesn't work" and the like. It looked like the SETOF operations were
being handled by the code under SETS_FIXED hence my original question.

Joshua b. Jore
http://www.greentechnologist.org

On Tue, 5 Feb 2002, Tom Lane wrote:

> "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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (OpenBSD)
Comment: For info see http://www.gnupg.org

iD8DBQE8Y997fexLsowstzcRAoeIAJ91gRdLOcxRbtfEExsO+UEEhlRtwgCguQrT
Ra4hldGhMbgnStWMaimjIso=
=VK7R
-----END PGP SIGNATURE-----


pgsql-novice by date:

Previous
From: Dominique Duflos
Date:
Subject: Re: Connecting a postgresql client to an oracle7 db
Next
From: John Taylor
Date:
Subject: Using indexes and keys