Thread: pgsql: Remove the aggregate form of ts_rewrite(), since it doesn't work
pgsql: Remove the aggregate form of ts_rewrite(), since it doesn't work
From
tgl@postgresql.org (Tom Lane)
Date:
Log Message: ----------- Remove the aggregate form of ts_rewrite(), since it doesn't work as desired if there are zero rows to aggregate over, and the API seems both conceptually and notationally ugly anyway. We should look for something that improves on the tsquery-and-text-SELECT version (which is also pretty ugly but at least it works...), but it seems that will take query infrastructure that doesn't exist today. (Hm, I wonder if there's anything in or near SQL2003 window functions that would help?) Per discussion. Modified Files: -------------- pgsql/doc/src/sgml: textsearch.sgml (r1.24 -> r1.25) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/textsearch.sgml?r1=1.24&r2=1.25) pgsql/src/backend/utils/adt: tsquery_rewrite.c (r1.5 -> r1.6) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/tsquery_rewrite.c?r1=1.5&r2=1.6) pgsql/src/include/catalog: catversion.h (r1.436 -> r1.437) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/catversion.h?r1=1.436&r2=1.437) pg_aggregate.h (r1.63 -> r1.64) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_aggregate.h?r1=1.63&r2=1.64) pg_proc.h (r1.476 -> r1.477) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_proc.h?r1=1.476&r2=1.477) pgsql/src/include/tsearch: ts_type.h (r1.6 -> r1.7) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/tsearch/ts_type.h?r1=1.6&r2=1.7) pgsql/src/test/regress/expected: tsearch.out (r1.5 -> r1.6) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/tsearch.out?r1=1.5&r2=1.6) pgsql/src/test/regress/sql: tsearch.sql (r1.3 -> r1.4) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/tsearch.sql?r1=1.3&r2=1.4)