diff options
Diffstat (limited to 'contrib/tsearch2/sql')
| -rw-r--r-- | contrib/tsearch2/sql/tsearch2.sql | 6 |
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; + |