pgsql: Remove the aggregate form of ts_rewrite(), since it doesn't work - Mailing list pgsql-committers

From tgl@postgresql.org (Tom Lane)
Subject pgsql: Remove the aggregate form of ts_rewrite(), since it doesn't work
Date
Msg-id 20071024022449.B9761754229@cvs.postgresql.org
Whole thread Raw
List pgsql-committers
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)

pgsql-committers by date:

Previous
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: Make configure probe for the location of the header
Next
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: Set read_only = TRUE while evaluating input queries for