> huh. what it is the standard for equivalence? I guess we'd be
> following javascript ===, right?
> (http://dorey.github.io/JavaScript-Equality-Table/).
right.
But in your link I don't understand array (and object) equality rules. Hstore
(and jsonb) compare function believes that arrays are equal if each
corresponding elements of them are equal.
postgres=# select 'a=>[]'::hstore = 'a=>[]'::hstore; ?column?
---------- t
(1 row)
Time: 0,576 ms
postgres=# select 'a=>[0]'::hstore = 'a=>[0]'::hstore; ?column?
---------- t
(1 row)
Time: 0,663 ms
postgres=# select 'a=>[0]'::hstore = 'a=>[1]'::hstore; ?column?
---------- f
--
Teodor Sigaev E-mail: teodor@sigaev.ru
WWW: http://www.sigaev.ru/