diff options
author | Heikki Linnakangas <heikki.linnakangas@iki.fi> | 2015-07-21 20:54:18 +0300 |
---|---|---|
committer | Heikki Linnakangas <heikki.linnakangas@iki.fi> | 2015-07-21 20:59:24 +0300 |
commit | c6fbe6d6fb828f50b9d67627588eb5ab8bd25e47 (patch) | |
tree | b479aea613e779de9564a667c32e1f36962c5a3d /contrib/intarray/sql/_int.sql | |
parent | 434873806a9b1c0edd53c2a9df7c93a8ba021147 (diff) | |
download | postgresql-c6fbe6d6fb828f50b9d67627588eb5ab8bd25e47.tar.gz postgresql-c6fbe6d6fb828f50b9d67627588eb5ab8bd25e47.zip |
Add selectivity estimation functions for intarray operators.
Uriy Zhuravlev and Alexander Korotkov, reviewed by Jeff Janes, some cleanup
by me.
Diffstat (limited to 'contrib/intarray/sql/_int.sql')
-rw-r--r-- | contrib/intarray/sql/_int.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/contrib/intarray/sql/_int.sql b/contrib/intarray/sql/_int.sql index 216c5c58d61..f6fe2de55c5 100644 --- a/contrib/intarray/sql/_int.sql +++ b/contrib/intarray/sql/_int.sql @@ -68,8 +68,8 @@ SELECT '1&(2&(4&(5|!6)))'::query_int; CREATE TABLE test__int( a int[] ); - \copy test__int from 'data/test__int.data' +ANALYZE test__int; SELECT count(*) from test__int WHERE a && '{23,50}'; SELECT count(*) from test__int WHERE a @@ '23|50'; |