From f10eab73df2b94c860dea4a906c54e3c903f42e2 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Fri, 5 Aug 2016 16:09:06 -0400 Subject: Make array_to_tsvector() sort and de-duplicate the given strings. This is required for the result to be a legal tsvector value. Noted while fooling with Andreas Seltenreich's ts_delete() crash. Discussion: <87invhoj6e.fsf@credativ.de> --- doc/src/sgml/func.sgml | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'doc/src') diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 971e642276c..783033403a4 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -9294,7 +9294,7 @@ CREATE TYPE rainbow AS ENUM ('red', 'orange', 'yellow', 'green', 'blue', 'purple tsvector convert array of lexemes to tsvector array_to_tsvector('{fat,cat,rat}'::text[]) - 'fat' 'cat' 'rat' + 'cat' 'fat' 'rat' -- cgit v1.2.3