ublic.attend"
If I want to detect the same thing, should I execute REINDEX sometimes?
Do you have any good ideas?
Thanks.
---
http://github.com/yalab
Atsushi YOSHIDA <rudeboy...@gmail.com>
http://twitter.com/yalab inject your heart
> 2015/09/07 7:47、Jeff Janes <jeff.ja...@gmail.
" IN ('ABF0010',
> 'ABF0020', 'ABF0030', 'ABF0040', 'ABF0050', 'ABF0060')
>
> Index Scan using index_attend_on_sid_and_lid on attend (cost=0.42..36.32
> rows=3 width=12) (actual time=0.011..0.034 rows=6 loops=1)
>Index Cond: ((sid = 325) AND (lid = ANY
> ('{ABF001
5 rows)
This IN condition to be unique and execute it like this.
> arcvideo=> SELECT "attend"."lid", "attend"."status" FROM "attend" WHERE
> "attend"."sid" = 325 AND "attend"."lid" IN ('ABF0010', 'ABF0020', 'ABF0030',
> 'ABF0040', 'ABF0050', 'ABF0060’);
It return
>lid |