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