On 09/06/2011 07:34 PM, Oleg Bartunov wrote: > Here is the latest spgist patch, which has all planned features as > well as > all overhead, introduced by concurrency and recovery, so performance > measurement should be realistic now. > > Oleg
Sorry for not getting the might-be-obvious here, but will this patch bring indexed substring-search to PG? So queries conceptually equal to this will be possible to index: WHERE som_col @@ ':substr1:&:substr2!substr3:' meaning "contains substr1" AND "ends with substr2" OR "starts with substr3"? -- Andreas Joseph Krogh <andr...@officenet.no> - mob: +47 909 56 963 Senior Software Developer / CTO - OfficeNet AS - http://www.officenet.no Public key: http://home.officenet.no/~andreak/public_key.asc -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
