> My question is, if one can get also index support for the '->' operator? I am not sure what do you mean. >>> SELECT id, (kvp->'a') FROM mytable; >>> >>> ... can be accelerated nevertheless by adding following where clause: >>> >>> SELECT id, (kvp->'a') FROM mytable WHERE kvp ? 'a'; >>> >>> => Is this correct? These queries could return completely different result sets. First query returns all the records with the value of kvp->'a' if kvp has 'a' key and NULL otherwise. Second one returns only those records where kvp has 'a' key. -- Sergey Konoplev Blog: http://gray-hemp.blogspot.com / Linkedin: http://ru.linkedin.com/in/grayhemp / JID/GTalk: gray.ru@xxxxxxxxx / Skype: gray-hemp / ICQ: 29353802 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
