diff options
| author | Tom Lane | 2007-10-24 02:24:49 +0000 |
|---|---|---|
| committer | Tom Lane | 2007-10-24 02:24:49 +0000 |
| commit | 592c88a0d2d9059576ad4f823dcc6e1ffbd1acfc (patch) | |
| tree | d53cf4db92c4972e45c5e47b1174d89dac23c7f1 /doc/src | |
| parent | 07d0a370c13545755aec57839530fe14e83be092 (diff) | |
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.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/textsearch.sgml | 29 |
1 files changed, 1 insertions, 28 deletions
diff --git a/doc/src/sgml/textsearch.sgml b/doc/src/sgml/textsearch.sgml index 64a5929e1a7..7ebebeb19c7 100644 --- a/doc/src/sgml/textsearch.sgml +++ b/doc/src/sgml/textsearch.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/textsearch.sgml,v 1.24 2007/10/23 20:46:12 tgl Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/textsearch.sgml,v 1.25 2007/10/24 02:24:47 tgl Exp $ --> <chapter id="textsearch"> <title id="textsearch-title">Full Text Search</title> @@ -1460,33 +1460,6 @@ SELECT ts_rewrite('a & b'::tsquery, 'a'::tsquery, 'c'::tsquery); <term> <synopsis> - ts_rewrite(ARRAY[<replaceable class="PARAMETER">query</replaceable> <type>tsquery</>, <replaceable class="PARAMETER">target</replaceable> <type>tsquery</>, <replaceable class="PARAMETER">substitute</replaceable> <type>tsquery</>]) returns <type>tsquery</> - </synopsis> - </term> - - <listitem> - <para> - Aggregate form. XXX if we choose not to remove this, it needs to - be documented better. Note it is not listed in - textsearch-functions-table at the moment. - -<programlisting> -CREATE TABLE aliases (t tsquery PRIMARY KEY, s tsquery); -INSERT INTO aliases VALUES('a', 'c'); - -SELECT ts_rewrite(ARRAY['a & b'::tsquery, t,s]) FROM aliases; - ts_rewrite ------------- - 'b' & 'c' -</programlisting> - </para> - </listitem> - </varlistentry> - - <varlistentry> - - <term> - <synopsis> ts_rewrite (<replaceable class="PARAMETER">query</> <type>tsquery</>, <replaceable class="PARAMETER">select</> <type>text</>) returns <type>tsquery</> </synopsis> </term> |