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 <andreak(at)officenet(dot)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