On Wed, Sep 16, 2009 at 5:24 PM, John R Pierce <pie...@hogranch.com> wrote: > why would you store data thats wrapped in two copies of its fieldname along > with other punctuation? wouldn't it make more sense to decompose your XML > source into proper tables so proper indexes and relational sql queries can > be made? otherwise, every query turns into a massive sequential scan and > parsing operation.
you can always have index on xpath() ... and than use same expression in WHERE, and postgresql will use index. -- GJ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
