~ubuntu-branches/ubuntu/hardy/postgresql-8.4/hardy-backports

« back to all changes in this revision

Viewing changes to src/pl/plpython/sql/plpython_function.sql

Committer: Bazaar Package Importer
Author(s): Martin Pitt
Date: 2011-01-03 08:57:10 UTC
mfrom: (5.3.10 sid)
Revision ID: james.westby@ubuntu.com-20110103085710-v9u121v7u7oq8qca

Tags: 8.4.6-1~hardy1

Automated backport upload; no source changes.

files added:
.gitignore

contrib/adminpack/.gitignore

contrib/btree_gin/.gitignore

contrib/btree_gist/.gitignore

contrib/chkpass/.gitignore

contrib/citext/.gitignore

contrib/cube/.gitignore

contrib/dblink/.gitignore

contrib/dict_int/.gitignore

contrib/dict_xsyn/.gitignore

contrib/earthdistance/.gitignore

contrib/fuzzystrmatch/.gitignore

contrib/hstore/.gitignore

contrib/intarray/.gitignore

contrib/isn/.gitignore

contrib/lo/.gitignore

contrib/ltree/.gitignore

contrib/oid2name/.gitignore

contrib/pageinspect/.gitignore

contrib/pg_archivecleanup

contrib/pg_archivecleanup/.gitignore

contrib/pg_buffercache/.gitignore

contrib/pg_freespacemap/.gitignore

contrib/pg_standby/.gitignore

contrib/pg_stat_statements/.gitignore

contrib/pg_trgm/.gitignore

contrib/pg_upgrade

contrib/pg_upgrade/.gitignore

contrib/pgbench/.gitignore

contrib/pgcrypto/.gitignore

contrib/pgrowlocks/.gitignore

contrib/pgstattuple/.gitignore

contrib/seg/.gitignore

contrib/spi/.gitignore

contrib/sslinfo/.gitignore

contrib/tablefunc/.gitignore

contrib/test_parser/.gitignore

contrib/tsearch2/.gitignore

contrib/unaccent

contrib/unaccent/.gitignore

contrib/vacuumlo/.gitignore

contrib/xml2/.gitignore

debian/postgresql-8.4.preinst

doc/src/sgml/.gitignore

doc/src/sgml/sourcerepo.sgml

src/.gitignore

src/backend/.gitignore

src/backend/bootstrap/.gitignore

src/backend/catalog/.gitignore

src/backend/parser/.gitignore

src/backend/po/ko.po

src/backend/po/zh_TW.po

src/backend/port/.gitignore

src/backend/snowball/.gitignore

src/backend/storage/file/copydir.c

src/backend/utils/.gitignore

src/backend/utils/mb/conversion_procs/.gitignore

src/backend/utils/misc/.gitignore

src/bin/initdb/.gitignore

src/bin/initdb/po/ko.po

src/bin/initdb/po/zh_TW.po

src/bin/pg_config/.gitignore

src/bin/pg_config/po/zh_TW.po

src/bin/pg_controldata/.gitignore

src/bin/pg_controldata/po/zh_TW.po

src/bin/pg_ctl/.gitignore

src/bin/pg_ctl/po/zh_TW.po

src/bin/pg_dump/.gitignore

src/bin/pg_dump/po/ko.po

src/bin/pg_dump/po/zh_TW.po

src/bin/pg_resetxlog/.gitignore

src/bin/pg_resetxlog/po/zh_TW.po

src/bin/psql/.gitignore

src/bin/psql/po/ko.po

src/bin/psql/po/zh_TW.po

src/bin/scripts/.gitignore

src/bin/scripts/po/zh_TW.po

src/include/.gitignore

src/include/catalog/.gitignore

src/include/parser/.gitignore

src/include/utils/.gitignore

src/interfaces/ecpg/compatlib/.gitignore

src/interfaces/ecpg/ecpglib/.gitignore

src/interfaces/ecpg/include/.gitignore

src/interfaces/ecpg/pgtypeslib/.gitignore

src/interfaces/ecpg/preproc/.gitignore

src/interfaces/ecpg/preproc/po/ko.po

src/interfaces/ecpg/preproc/po/zh_TW.po

src/interfaces/ecpg/test/.gitignore

src/interfaces/ecpg/test/compat_informix/.gitignore

src/interfaces/ecpg/test/connect/.gitignore

src/interfaces/ecpg/test/pgtypeslib/.gitignore

src/interfaces/ecpg/test/preproc/.gitignore

src/interfaces/ecpg/test/sql/.gitignore

src/interfaces/ecpg/test/thread/.gitignore

src/interfaces/libpq/.gitignore

src/interfaces/libpq/po/zh_TW.po

src/pl/plperl/.gitignore

src/pl/plpgsql/src/.gitignore

src/pl/plpgsql/src/po/ko.po

src/pl/plpgsql/src/po/pt_BR.po

src/pl/plpgsql/src/po/zh_TW.po

src/pl/plpython/.gitignore

src/pl/tcl/.gitignore

src/pl/tcl/modules/.gitignore

src/port/.gitignore

src/test/regress/.gitignore

src/test/regress/expected/.gitignore

src/test/regress/sql/.gitignore

src/timezone/.gitignore

files removed:
contrib/cube/.cvsignore

contrib/seg/.cvsignore

debian/postgresql-8.4.init

doc/src/sgml/cvs.sgml

src/backend/bootstrap/.cvsignore

src/backend/parser/.cvsignore

src/backend/utils/.cvsignore

src/backend/utils/misc/.cvsignore

src/bin/psql/.cvsignore

src/interfaces/ecpg/compatlib/.cvsignore

src/interfaces/ecpg/ecpglib/.cvsignore

src/interfaces/ecpg/pgtypeslib/.cvsignore

src/interfaces/ecpg/preproc/.cvsignore

src/interfaces/libpq/.cvsignore

src/pl/plpgsql/src/.cvsignore

src/port/copydir.c

files modified:
GNUmakefile.in

HISTORY

INSTALL

configure

configure.in

contrib/cube/cube.c

contrib/dblink/dblink.c

contrib/dblink/expected/dblink.out

contrib/dblink/sql/dblink.sql

contrib/dblink/uninstall_dblink.sql

contrib/hstore/hstore.sql.in

contrib/hstore/uninstall_hstore.sql

contrib/pg_standby/pg_standby.c

contrib/pgcrypto/pgp-pubenc.c

contrib/xml2/xpath.c

debian/changelog

debian/control

debian/postgresql-8.4.prerm

debian/rules

doc/bug.template

doc/man.tar.gz

doc/postgres.tar.gz

doc/src/sgml/acronyms.sgml

doc/src/sgml/catalogs.sgml

doc/src/sgml/config.sgml

doc/src/sgml/datatype.sgml

doc/src/sgml/docguide.sgml

doc/src/sgml/earthdistance.sgml

doc/src/sgml/ecpg.sgml

doc/src/sgml/filelist.sgml

doc/src/sgml/hstore.sgml

doc/src/sgml/install-win32.sgml

doc/src/sgml/installation.sgml

doc/src/sgml/libpq.sgml

doc/src/sgml/lobj.sgml

doc/src/sgml/perform.sgml

doc/src/sgml/pgcrypto.sgml

doc/src/sgml/pgstandby.sgml

doc/src/sgml/plperl.sgml

doc/src/sgml/plpgsql.sgml

doc/src/sgml/pltcl.sgml

doc/src/sgml/postgres.sgml

doc/src/sgml/problems.sgml

doc/src/sgml/ref/create_table.sgml

doc/src/sgml/ref/create_view.sgml

doc/src/sgml/ref/grant.sgml

doc/src/sgml/ref/pg_restore.sgml

doc/src/sgml/ref/psql-ref.sgml

doc/src/sgml/release-7.4.sgml

doc/src/sgml/release-8.0.sgml

doc/src/sgml/release-8.1.sgml

doc/src/sgml/release-8.2.sgml

doc/src/sgml/release-8.3.sgml

doc/src/sgml/release-8.4.sgml

doc/src/sgml/release.sgml

doc/src/sgml/rules.sgml

doc/src/sgml/runtime.sgml

doc/src/sgml/syntax.sgml

doc/src/sgml/wal.sgml

doc/src/sgml/xfunc.sgml

doc/src/sgml/xml2.sgml

src/backend/access/common/reloptions.c

src/backend/access/gin/ginget.c

src/backend/access/gin/ginscan.c

src/backend/access/gin/ginxlog.c

src/backend/access/gist/gist.c

src/backend/access/gist/gistutil.c

src/backend/access/gist/gistvacuum.c

src/backend/access/heap/heapam.c

src/backend/access/heap/rewriteheap.c

src/backend/access/nbtree/nbtinsert.c

src/backend/access/nbtree/nbtpage.c

src/backend/access/transam/xact.c

src/backend/access/transam/xlog.c

src/backend/catalog/dependency.c

src/backend/catalog/index.c

src/backend/catalog/namespace.c

src/backend/catalog/pg_shdepend.c

src/backend/commands/analyze.c

src/backend/commands/indexcmds.c

src/backend/commands/opclasscmds.c

src/backend/commands/tablecmds.c

src/backend/commands/trigger.c

src/backend/commands/variable.c

src/backend/executor/execQual.c

src/backend/executor/functions.c

src/backend/executor/nodeMergejoin.c

src/backend/executor/nodeSubplan.c

src/backend/nls.mk

src/backend/nodes/copyfuncs.c

src/backend/nodes/equalfuncs.c

src/backend/nodes/outfuncs.c

src/backend/optimizer/path/allpaths.c

src/backend/optimizer/path/costsize.c

src/backend/optimizer/plan/createplan.c

src/backend/optimizer/plan/initsplan.c

src/backend/optimizer/plan/planmain.c

src/backend/optimizer/prep/prepjointree.c

src/backend/optimizer/util/clauses.c

src/backend/optimizer/util/placeholder.c

src/backend/optimizer/util/var.c

src/backend/parser/analyze.c

src/backend/parser/parse_expr.c

src/backend/parser/parse_func.c

src/backend/parser/parse_oper.c

src/backend/po/de.po

src/backend/po/es.po

src/backend/po/fr.po

src/backend/po/pt_BR.po

src/backend/po/zh_CN.po

src/backend/postmaster/autovacuum.c

src/backend/postmaster/postmaster.c

src/backend/storage/file/Makefile

src/backend/storage/file/fd.c

src/backend/tcop/fastpath.c

src/backend/tcop/postgres.c

src/backend/tsearch/ts_selfuncs.c

src/backend/tsearch/ts_typanalyze.c

src/backend/utils/adt/datetime.c

src/backend/utils/adt/geo_ops.c

src/backend/utils/adt/like_match.c

src/backend/utils/adt/ruleutils.c

src/backend/utils/adt/tsquery_op.c

src/backend/utils/adt/tsquery_util.c

src/backend/utils/cache/lsyscache.c

src/backend/utils/cache/plancache.c

src/backend/utils/cache/relcache.c

src/backend/utils/cache/typcache.c

src/backend/utils/init/miscinit.c

src/backend/utils/misc/postgresql.conf.sample

src/backend/utils/misc/ps_status.c

src/backend/utils/mmgr/portalmem.c

src/backend/utils/sort/tuplestore.c

src/bin/initdb/nls.mk

src/bin/initdb/po/cs.po

src/bin/initdb/po/de.po

src/bin/initdb/po/es.po

src/bin/initdb/po/it.po

src/bin/initdb/po/sv.po

src/bin/initdb/po/tr.po

src/bin/initdb/po/zh_CN.po

src/bin/pg_config/nls.mk

src/bin/pg_config/po/es.po

src/bin/pg_config/po/ko.po

src/bin/pg_config/po/zh_CN.po

src/bin/pg_controldata/nls.mk

src/bin/pg_controldata/po/es.po

src/bin/pg_controldata/po/ko.po

src/bin/pg_controldata/po/zh_CN.po

src/bin/pg_ctl/nls.mk

src/bin/pg_ctl/po/es.po

src/bin/pg_ctl/po/ko.po

src/bin/pg_ctl/po/zh_CN.po

src/bin/pg_dump/nls.mk

src/bin/pg_dump/pg_backup_archiver.c

src/bin/pg_dump/pg_backup_custom.c

src/bin/pg_dump/pg_dump.c

src/bin/pg_dump/po/de.po

src/bin/pg_dump/po/es.po

src/bin/pg_dump/po/fr.po

src/bin/pg_dump/po/pt_BR.po

src/bin/pg_dump/po/zh_CN.po

src/bin/pg_resetxlog/nls.mk

src/bin/pg_resetxlog/po/es.po

src/bin/pg_resetxlog/po/ko.po

src/bin/pg_resetxlog/po/zh_CN.po

src/bin/psql/common.c

src/bin/psql/mbprint.c

src/bin/psql/nls.mk

src/bin/psql/po/de.po

src/bin/psql/po/es.po

src/bin/psql/po/fr.po

src/bin/psql/po/pt_BR.po

src/bin/psql/po/sv.po

src/bin/psql/po/zh_CN.po

src/bin/scripts/nls.mk

src/bin/scripts/po/es.po

src/bin/scripts/po/ko.po

src/bin/scripts/po/zh_CN.po

src/include/access/gin.h

src/include/access/gist_private.h

src/include/access/xlogdefs.h

src/include/commands/defrem.h

src/include/nodes/execnodes.h

src/include/nodes/relation.h

src/include/optimizer/placeholder.h

src/include/parser/parse_func.h

src/include/pg_config.h.win32

src/include/port/linux.h

src/include/port/win32.h

src/include/utils/portal.h

src/include/utils/typcache.h

src/interfaces/ecpg/ecpglib/misc.c

src/interfaces/ecpg/ecpglib/po/es.po

src/interfaces/ecpg/ecpglib/po/zh_CN.po

src/interfaces/ecpg/pgtypeslib/numeric.c

src/interfaces/ecpg/preproc/nls.mk

src/interfaces/ecpg/preproc/parse.pl

src/interfaces/ecpg/preproc/po/es.po

src/interfaces/ecpg/preproc/po/zh_CN.po

src/interfaces/ecpg/preproc/preproc.c

src/interfaces/ecpg/preproc/preproc.y

src/interfaces/ecpg/test/Makefile.regress

src/interfaces/ecpg/test/compat_informix/dec_test.pgc

src/interfaces/ecpg/test/expected/compat_informix-dec_test.c

src/interfaces/ecpg/test/expected/pgtypeslib-dt_test.c

src/interfaces/ecpg/test/expected/pgtypeslib-dt_test.stderr

src/interfaces/ecpg/test/expected/pgtypeslib-dt_test2.c

src/interfaces/ecpg/test/expected/pgtypeslib-num_test.c

src/interfaces/ecpg/test/expected/pgtypeslib-num_test.stderr

src/interfaces/ecpg/test/expected/pgtypeslib-num_test2.c

src/interfaces/ecpg/test/expected/sql-array.c

src/interfaces/ecpg/test/pgtypeslib/dt_test.pgc

src/interfaces/ecpg/test/pgtypeslib/dt_test2.pgc

src/interfaces/ecpg/test/pgtypeslib/num_test.pgc

src/interfaces/ecpg/test/pgtypeslib/num_test2.pgc

src/interfaces/ecpg/test/sql/array.pgc

src/interfaces/libpq/fe-auth.c

src/interfaces/libpq/fe-secure.c

src/interfaces/libpq/libpq-dist.rc

src/interfaces/libpq/libpq-int.h

src/interfaces/libpq/libpq.rc.in

src/interfaces/libpq/nls.mk

src/interfaces/libpq/po/de.po

src/interfaces/libpq/po/es.po

src/interfaces/libpq/po/fr.po

src/interfaces/libpq/po/ko.po

src/interfaces/libpq/po/pt_BR.po

src/interfaces/libpq/po/zh_CN.po

src/pl/plperl/plperl.c

src/pl/plperl/po/de.po

src/pl/plperl/po/es.po

src/pl/plperl/po/fr.po

src/pl/plperl/po/pt_BR.po

src/pl/plperl/po/zh_CN.po

src/pl/plpgsql/src/gram.y

src/pl/plpgsql/src/nls.mk

src/pl/plpgsql/src/pl_exec.c

src/pl/plpgsql/src/pl_gram.c

src/pl/plpgsql/src/plpgsql.h

src/pl/plpgsql/src/po/de.po

src/pl/plpgsql/src/po/es.po

src/pl/plpgsql/src/po/fr.po

src/pl/plpgsql/src/po/zh_CN.po

src/pl/plpython/expected/plpython_function.out

src/pl/plpython/expected/plpython_test.out

src/pl/plpython/plpython.c

src/pl/plpython/po/de.po

src/pl/plpython/po/es.po

src/pl/plpython/po/fr.po

src/pl/plpython/po/pt_BR.po

src/pl/plpython/po/zh_CN.po

src/pl/plpython/sql/plpython_function.sql

src/pl/plpython/sql/plpython_test.sql

src/pl/tcl/pltcl.c

src/pl/tcl/po/es.po

src/pl/tcl/po/zh_CN.po

src/port/Makefile

src/port/win32ver.rc

src/test/regress/expected/horology.out

src/test/regress/expected/join.out

src/test/regress/expected/plpgsql.out

src/test/regress/expected/rangefuncs.out

src/test/regress/expected/strings.out

src/test/regress/expected/subselect.out

src/test/regress/sql/horology.sql

src/test/regress/sql/join.sql

src/test/regress/sql/plpgsql.sql

src/test/regress/sql/rangefuncs.sql

src/test/regress/sql/strings.sql

src/test/regress/sql/subselect.sql

src/timezone/data/africa

src/timezone/data/asia

src/timezone/data/australasia

src/timezone/data/backward

src/timezone/data/europe

src/timezone/data/leapseconds

src/timezone/data/northamerica

src/timezone/data/zone.tab

src/timezone/pgtz.c

src/timezone/tznames/Default

src/timezone/tznames/Pacific.txt

src/tools/fsync/test_fsync.c

src/tools/msvc/Mkvcbuild.pm

src/tools/msvc/vcregress.pl

Show diffs side-by-side

added added

removed removed

src/pl/plpython/sql/plpython_function.sql

448

return producer(count, content)

449

$$ LANGUAGE plpythonu;

450

451

CREATE FUNCTION test_setof_spi_in_iterator() RETURNS SETOF text AS

452

453

for s in ('Hello', 'Brave', 'New', 'World'):

454

plpy.execute('select 1')

455

yield s

456

plpy.execute('select 2')

457

458

LANGUAGE plpythonu;

459

451

460

452

461

453

462

-- Test returning tuples

Older »