Re: [GENERAL] custom index

2010-03-02 Thread Simon Riggs
On Mon, 2010-03-01 at 14:52 +0100, michael uwe maier wrote: > i want to develop an index for a special problem. > The postgres docs shows the necessary bits in > http://www.postgresql.org/docs/8.4/interactive/indexam.html > especially paragraph 50.2 "Index Access Method Functions". > >

[GENERAL] custom index

2010-03-01 Thread michael uwe maier
Hi , i want to develop an index for a special problem. The postgres docs shows the necessary bits in http://www.postgresql.org/docs/8.4/interactive/indexam.html especially paragraph 50.2 "Index Access Method Functions". Now my question: can i use the (documented) Server Programming

[GENERAL] Custom index type for indexing long texts?

2007-01-16 Thread Aleksander Kmetec
Hi, I'm looking for a solution for indexing long TEXT columns. We're currently using a HASH index, which can handle most situations, but every now and then we need support for even longer texts. One solution would be to create a functional index which would only use the first N chars of mycol,