[GENERAL] using hstore to store documents

2017-01-26 Thread Rita
Is it possible to use hstore to store xml document? I would like to have "status" => "..."::xml -- --- Get your facts first, then you can distort them as you please.--

Re: [GENERAL] using hstore to store documents

2017-01-26 Thread Rita
table of my xpath results and have clients query that table (xpath can be expensive). So, I was wondering if hstore will help me for fast access. Please let me know if anything is unclear. On Thu, Jan 26, 2017 at 3:58 AM, Tomas Vondra wrote: > On 01/26/2017 09:08 AM, Rita wrote: > &g

Re: [GENERAL] using hstore to store documents

2017-01-28 Thread Rita
e accessing the downstream tables and rarely be touching xmltest (head table). On Thu, Jan 26, 2017 at 10:38 AM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Thu, Jan 26, 2017 at 5:37 AM, Rita wrote: > >> of course, sorry for being vague. >> >> I have an

Re: [GENERAL] using hstore to store documents

2017-01-29 Thread Rita
ian Klaver wrote: > On 01/28/2017 05:57 PM, Rita wrote: > >> sorry for the late reply. >> >> My table schema is very simple >> >> DROP TABLE xmltest; >> >> >> >> >> >> create table xmltest( >> >> >> id s

Re: [GENERAL] using hstore to store documents

2017-01-31 Thread Rita
-> table 1_master -> table 2_master -> table 3_master -> table 1_table3 On Sun, Jan 29, 2017 at 9:45 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Saturday, January 28, 2017, Rita wrote: > >> After xmltest has been populated