Hi, I'm looking into supporting full text search queries with DBLinq and PostgreSQL, and I'd appreciate some directions.
PosgreSQL stores the "hash" of the text that should be matched in columns of type 'tsvector', such that searches are quite fast. http://www.postgresql.org/docs/8.4/static/textsearch.html For example, you have a table like the following: table1 col1:text | col2:tsvector ----------|------------------ foo bar | tsvector(foo bar) bar baz | tsvector(bar baz) If you want to search for 'foo' you do this: SELECT * FROM table1 WHERE col2 @@ 'foo'; I've added an empty TsVector type in the DbLinq.PostgreSql namespace and added support for it when generating with DbMetal, such that a simple query testing for not-nullness of col2 works. I'd like to add a TsVector.Matches(string) method that gets converted to the '@@' operator, but I need some advice. I've thought about adding a new SpecialExpressionType but this is quite postgres-specific, so I'm not sure if this is the right course of action. Suggestions? -- Buongiorno. Complimenti per l'ottima scelta. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "DbLinq" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/dblinq?hl=en -~----------~----~----~----~------~----~------~--~---
