1 Minimize memory allocation for void (but not null) value.

2 Add silly ordering for ts_vector to aim grouping, union, except etc. Don't use BTree opclass (tsvector_ops).

1 files changed, 6 insertions, 0 deletions

diff --git a/contrib/tsearch2/sql/tsearch2.sql b/contrib/tsearch2/sql/tsearch2.sql
index d4f1021d7d8..6e8edc3fb25 100644
--- a/contrib/tsearch2/sql/tsearch2.sql
+++ b/contrib/tsearch2/sql/tsearch2.sql
@@ -247,3 +247,9 @@ Upon a woman s face. E.  J.  Pratt  (1882 1964)
 
 --check debug
 select * from ts_debug('Tsearch module for PostgreSQL 7.3.3');
+
+--check ordering
+drop trigger tsvectorupdate on test_tsvector;
+insert into test_tsvector values (null, null);
+select a is null, a from test_tsvector order by a;
+