Re: SETOF / SETS_FIXED?

From: "Joshua b(dot) Jore" <josh(at)greentechnologist(dot)org>
To:
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: SETOF / SETS_FIXED?
Date: 2002-02-08 14:23:52
Message-ID: Pine.BSO.4.40.0202070701150.16805-100000@kitten.greentechnologist.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)greentechnologist(dot)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-----

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message John Taylor 2002-02-08 16:50:42 Using indexes and keys
Previous Message Dominique Duflos 2002-02-08 12:27:39 Re: Connecting a postgresql client to an oracle7 db