Re: Array: comparing first N elements?

From: David Garamond <davidgaramond(at)gmail(dot)com>
To: Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Array: comparing first N elements?
Date: 2009-05-12 08:42:22
Message-ID: 7c33d060905120142t75d1c887jfe62f21361eac178@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

2009/5/12 Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>

> you would want to look at the intarray contrib package for index suppor and
> many other goodies,
> also you might want to write fucntions first(parents), last(parents) and
> then have an index
> on those as well.
> This way searching for the direct children of a node is very fast.

Thanks for the suggestions! Index support is exactly what I'm looking for.
Will look into intarray.

Regards,
dave

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Maximilian Tyrtania 2009-05-12 16:39:29 Re: Distinct oddity
Previous Message David Garamond 2009-05-12 08:40:02 Re: Array: comparing first N elements?