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