On Tue, 2007-11-13 at 08:58 +0100, Pavel Stehule wrote: > On 13/11/2007, Simon Riggs <[EMAIL PROTECTED]> wrote:
> > I'm thinking we can have an inlinable function > > > > contains(text, text) returns int > > > > Return values limited to just 0 or 1 or NULL, as with SQL/MM. > > It's close to SQL/MM, but not exact. > > > > contains(sourceText, searchText) is a macro for > > > > case to_tsvector(default_text_search_config, sourceText) @@ > > to_tsquery(default_text_search_config, searchText) > > when true then 1 > > when false then 0 > > else null > > end > > > > it's look well. I think it needs lot more thought yet. Travelling now, so not able to add further. Will pick up again in next few days. -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
