Changed the create index statement to : USING hash and it seems to work.
Any idea why btree does not work ?
Thanks
Chris
On Thu, May 27, 2010 at 3:47 PM, Chris Roffler wrote:
> Tried that same thing
>
>
> On Thu, May 27, 2010 at 1:53 PM, Thom Brown wrote:
>
>> On 27 May 2010 12:22, Chr
Tried that same thing
On Thu, May 27, 2010 at 1:53 PM, Thom Brown wrote:
> On 27 May 2010 12:22, Chris Roffler wrote:
> > I have a table with an xml column, created an index as follows:
> > CREATE INDEX xml_index
> > ON test
> > USING btree
> > (((xpath('//*/ChangedBy/text()'::text,
On 27 May 2010 12:22, Chris Roffler wrote:
> I have a table with an xml column, created an index as follows:
> CREATE INDEX xml_index
> ON test
> USING btree
> (((xpath('//*/ChangedBy/text()'::text, external_attributes))[1]::text));
> And here is my select statement:
> Select uuid from t
>
Yup you are right however I am trying to run benchmarks with the two
solutions.
The xml solution will give us more flexibility in the future , just in case
we do not have attribute/value lists :)
On Mon, Mar 8, 2010 at 1:33 PM, Alban Hertroys <
dal...@solfertje.student.utwente.nl> wrote:
>
On 8 Mar 2010, at 13:23, Chris Roffler wrote:
> Alban
>
> thanks for your response. I understand what you are saying .
>
> >Your previous query wasn't about attributes in any specific position - it
> >returned documents that contained >more than zero attributes matching a
> >given name. Wh
Alban
thanks for your response. I understand what you are saying .
>Your previous query wasn't about attributes in any specific position - it
returned documents that contained >more than zero attributes matching a
given name. What are you trying to do this time?
And that is exactly my proble
On 8 Mar 2010, at 11:39, Chris Roffler wrote:
> Alban
>
> Thanks for your help, your suggestion worked.
>
> I need another xpath expression to find any Attribute with Name =""
> under the Attributes node. (not just if it is in a specific position)
> see query below.
> How do I create an
On 8 Mar 2010, at 11:39, Chris Roffler wrote:
> Alban
>
> Thanks for your help, your suggestion worked.
>
> I need another xpath expression to find any Attribute with Name =""
> under the Attributes node. (not just if it is in a specific position)
> see query below.
Your previous query
Alban
Thanks for your help, your suggestion worked.
I need another xpath expression to find any Attribute with Name =""
under the Attributes node. (not just if it is in a specific position)
see query below.
How do I create an index for this xpath expression ?
Thanks
Chris
SELECT * FROM
Alban
thanks for your replay. Yes I am looking for node exists ...
I'll give it a roll.
>There are a couple of cases where Postgres won't use your index, but in this
>case it's quite clearly because you're asking for (quite) a different
>expression than the one you indexed.
>
>You seem to wa
On 7 Mar 2010, at 11:02, Chris Roffler wrote:
> I still have some problems with my xml index
>
> CREATE INDEX xml_index
> ON time_series
> USING btree
> ((
> (xpath('/AttributeList/Attributes/Attribute/Name/text()',
> external_attributes))[1]::text));
>
> When I run the following query
11 matches
Mail list logo
