Joshua D. Drake wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Bruce Momjian wrote: > > Trevor Talbot wrote: > >> On 8/18/07, Bruce Momjian <[EMAIL PROTECTED]> wrote: > >> > >>> Remember an expression index can be a user-created function so you can > >>> embed whatever you want in your function and just index it's output, > >>> just like you would with a trigger creating a separate column. > >> Well, you could create a function that returns a tsvector, but how do > >> you get that to work with queries? I've been under the impression the > >> expressions need to match (in the normal case, be the same function > >> with the same arguments) in order to use the index. > > > > Yes, so you create a function called complex_ts and create the index: > > > > CREATE INDEX ii on x USING GIT(complex_ts(col1, col2)) > > GIN?
Yes, sorry, GIN. -- Bruce Momjian <[EMAIL PROTECTED]> http://momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
