Re: [GENERAL] tsearch2 headline() query subselect help

2007-01-10 Thread Jeff Davis
On Wed, 2007-01-10 at 19:14 -0500, John Smith wrote: > guys, > how'd i make this query work? > select headline(select column_1 from table_1 where to_tsvector > (column_1) @@ to_tsquery('ftp'),'ftp'::tsquery); > ERROR: syntax error at or near "select" at character 1

Re: [GENERAL] tsearch2 headline() query subselect help

2007-01-10 Thread Jeff Davis
On Wed, 2007-01-10 at 19:14 -0500, John Smith wrote: > guys, > how'd i make this query work? > select headline(select column_1 from table_1 where to_tsvector > (column_1) @@ to_tsquery('ftp'),'ftp'::tsquery); > ERROR: syntax error at or near "select" at character 1