Steven Lembark <lembark@xxxxxxxxxxx> writes: > On Thu, 10 May 2018 14:41:26 -0400 > Tom Lane <tgl@xxxxxxxxxxxxx> wrote: >> Steven Lembark <lembark@xxxxxxxxxxx> writes: >>> The problem is with gists telling me that they cannot index >>> the type. This works for enums, just not the composite type. >> Oh, well, they can't. There's no GiST opclass covering arbitrary >> composite types. This doesn't seem very surprising to me given >> the lack of operators that such an opclass might accelerate. > But I thought that they could include functions of composite > types that were indexable (e.g., text)? Yeah, but that's not what you did. I think you could make that work with exclude using gist ( lat_lng_text(location) with =, effective with && ) but it's not going to apply the function without you telling it to. regards, tom lane
