Re: tsearch2 headline() query subselect help - Mailing list pgsql-general

From Jeff Davis
Subject Re: tsearch2 headline() query subselect help
Date
Msg-id 1168477985.2411.7.camel@dogma.v10.wvs
Whole thread Raw
In response to tsearch2 headline() query subselect help  ("John Smith" <jayzee.smith@gmail.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: "Tomas Lanczos"
Date:
Subject: Moving the database from winxp to linux
Next
From: "Radovan Jablonov"
Date:
Subject: plpgsql trapping full detail error message