SETOF / SETS_FIXED?

From: "Joshua b(dot) Jore" <josh(at)greentechnologist(dot)org>
To: pgsql-novice(at)postgresql(dot)org
Subject: SETOF / SETS_FIXED?
Date: 2002-02-05 16:57:24
Message-ID: Pine.BSO.4.40.0202051049560.13344-100000@kitten.greentechnologist.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I'd like to write a sort of functional API for my database by writing
custome functions. It looks like if I want to return a result set I need
to declare the return type as a 'SETOF tablename'. The resultset appears
(please confirm this for me) to be oids where the appropriate syntax to
use the result is 'SELECT username(UserRetrieve(id)),
accesslevel(UserRetrieve(id))' from the function 'UserRetrive (int)'.

I'm ok with that though the syntax for using the result set is pretty
weird. 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. Is it ok to use
functions this way or is it still reserved for developers only?

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

iD8DBQE8YA75fexLsowstzcRAmdyAJ4yOSVkRbKc8Qrflq81+BBygJyZ3QCgqirj
6IM0GyRUMazAuAHsoUcmzc4=
=C/o0
-----END PGP SIGNATURE-----

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2002-02-05 17:34:46 Re: SETOF / SETS_FIXED?
Previous Message Tom Lane 2002-02-05 15:39:54 Re: Problem with joins