SETOF / SETS_FIXED?
От | Joshua b. Jore |
---|---|
Тема | SETOF / SETS_FIXED? |
Дата | |
Msg-id | Pine.BSO.4.40.0202051049560.13344-100000@kitten.greentechnologist.org обсуждение исходный текст |
Ответы |
Re: SETOF / SETS_FIXED?
|
Список | 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-----
В списке pgsql-novice по дате отправления: