Commit98fc1ba

authored and

committed

GIN: check && 'empty'

1 parent3fece18 commit98fc1baCopy full SHA for 98fc1ba

File tree

+13

-0

lines changed

+13

-0

lines changed

Lines changed: 10 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -45,6 +45,16 @@ SELECT ivoid FROM moc100 WHERE coverage && '4/0' ORDER BY ivoid;`
`45`	`45`	`ivo://vopdc.obspm/luth/hess`
`46`	`46`	`(35 rows)`
`47`	`47`
	`48`	`+EXPLAIN (ANALYZE, BUFFERS, TIMING OFF, SUMMARY OFF)`
	`49`	`+SELECT * FROM moc100 WHERE coverage && '0/';`
	`50`	`+ QUERY PLAN`
	`51`	`+----------------------------------------------------------------------------------------------------------`
	`52`	`+ Bitmap Heap Scan on moc100 (cost=0.00..4.01 rows=1 width=96) (actual rows=0 loops=1)`
	`53`	`+ Recheck Cond: (coverage && '0/'::smoc)`
	`54`	`+ -> Bitmap Index Scan on moc100_coverage_idx (cost=0.00..0.00 rows=1 width=0) (actual rows=0 loops=1)`
	`55`	`+ Index Cond: (coverage && '0/'::smoc)`
	`56`	`+(4 rows)`
	`57`	`+`
`48`	`58`	`EXPLAIN (ANALYZE, BUFFERS, TIMING OFF, SUMMARY OFF)`
`49`	`59`	`SELECT * FROM moc100 WHERE coverage && '4/0';`
`50`	`60`	`QUERY PLAN`

Lines changed: 3 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -111,6 +111,9 @@ CREATE INDEX ON moc100 USING GIN (coverage);`
`111`	`111`
`112`	`112`	`SELECT ivoidFROM moc100WHERE coverage &&'4/0'ORDER BY ivoid;`
`113`	`113`
	`114`	`+EXPLAIN (ANALYZE, BUFFERS, TIMING OFF, SUMMARY OFF)`
	`115`	`+SELECT*FROM moc100WHERE coverage &&'0/';`
	`116`	`+`
`114`	`117`	`EXPLAIN (ANALYZE, BUFFERS, TIMING OFF, SUMMARY OFF)`
`115`	`118`	`SELECT*FROM moc100WHERE coverage &&'4/0';`
`116`	`119`

Comments

(0)