Re: [GENERAL] index type for indexing long texts

2007-01-15 Thread Aleksander Kmetec
Thank you both for your suggestions. I think I'll try the GiST approach first since using an existing contrib extension as a starting point seems like a simpler task for someone like me. :) Regards, Aleksander Richard Troy wrote: Aleksander Kmetec <[EMAIL PROTECTED]> writes: I'm looking f

Re: [GENERAL] index type for indexing long texts

2007-01-13 Thread Richard Troy
> Aleksander Kmetec <[EMAIL PROTECTED]> writes: > > 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 funct

Re: [GENERAL] index type for indexing long texts

2007-01-13 Thread Tom Lane
Aleksander Kmetec <[EMAIL PROTECTED]> writes: > 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

[GENERAL] index type for indexing long texts

2007-01-13 Thread Aleksander Kmetec
(I'm reposting this because the original message didn't make it through in the last ~20 hours) 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. On