Re: tsearch2 headline() query subselect help

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 17
>

When passing a subselect as an argument to a function, you need to put
it in parenthesis, like so:

select myfunction((select ... from ...),'');

Regards,
    Jeff Davis