File: falcon.out

package info (click to toggle)
prefix 1.2.3-3
  • links: PTS, VCS
  • area: main
  • in suites: jessie, jessie-kfreebsd
  • size: 688 kB
  • ctags: 150
  • sloc: ansic: 1,313; sql: 756; makefile: 36; sh: 2
file content (21 lines) | stat: -rw-r--r-- 460 bytes parent folder | download | duplicates (7) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
 
drop table if exists tst;
NOTICE:  table "tst" does not exist, skipping
create table tst ( pref prefix_range );
insert into tst
     select trim(to_char(i, '00000'))
       from generate_series(1, 99999) as i;
select count(*) from tst where pref <@ '55';
 count 
-------
  1000
(1 row)

create index tst_ix on tst using gist ( pref );
set enable_seqscan = off;
select count(*) from tst where pref <@ '55';
 count 
-------
  1000
(1 row)

reset enable_seqscan;