Thread: example table functions?
Does anyone have some sample table functions they could post? I read in the archives about something in contrib but currently I only have 7.3 running in Cygwin (I am patiently waiting for the FreeBSD Postgresql port to be updated to 7.3) and I don't see any sign of contrib on Cygiwn... I'd love to tinker around with functions returning multiple rows without guessing at the syntax :) culley
culley harrelson wrote: > Does anyone have some sample table functions they could post? I read in > the archives about something in contrib but currently I only have 7.3 > running in Cygwin (I am patiently waiting for the FreeBSD Postgresql port > to be updated to 7.3) and I don't see any sign of contrib on Cygiwn... > I'd love to tinker around with functions returning multiple rows without > guessing at the syntax :) You didn't say which language you were looking for examples in, but I recently posted a plpgsql example here in Roberto Mello's PostgreSQL Cookbook: http://www.brasileiro.net:8080/postgres/cookbook/view-one-recipe.adp?recipe_id=11378 There are other plpgsql and sql function examples in the mailing list archives. Couple of examples: http://archives.postgresql.org/pgsql-general/2002-10/msg00022.php and http://archives.postgresql.org/pgsql-general/2002-12/msg00426.php There is a recent example in Elein Mustain's "General Bits" column: http://archives.postgresql.org/pgsql-general/2002-12/msg00426.php The contrib table functions are all C based. You can download them directly from cvs -- for instructions see: http://developer.postgresql.org/TODO/docs/cvs.html#ANONCVS or just to browse see: http://developer.postgresql.org/cvsweb.cgi/pgsql-server/contrib/dblink/ and http://developer.postgresql.org/cvsweb.cgi/pgsql-server/contrib/tablefunc/ And finally, in the manual see: general -> http://developer.postgresql.org/docs/postgres/xfunc-tablefunctions.html sql -> http://developer.postgresql.org/docs/postgres/xfunc-sql.html (sec 9.2.4) C -> http://developer.postgresql.org/docs/postgres/xfunc-c.html (sec 9.5.6) plpgsql -> http://developer.postgresql.org/docs/postgres/plpgsql-control-structures.html usage -> http://developer.postgresql.org/docs/postgres/sql-select.html (from_item, inputs, from clause, usage) Possibly others, but that's all I can think of. HTH, Joe
Joe Conway wrote: > There is a recent example in Elein Mustain's "General Bits" column: > http://archives.postgresql.org/pgsql-general/2002-12/msg00426.php > Oops! That was a cut-n-pasto. Here's the real link: http://www.varlena.com/GeneralBits/6.html Joe