Re: Re: External search engine, advice - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Re: External search engine, advice
Date
Msg-id 229.990286113@sss.pgh.pa.us
Whole thread Raw
In response to Re: External search engine, advice  (mlw <markw@mohawksoft.com>)
List pgsql-hackers
mlw <markw@mohawksoft.com> writes:
> freedb=# select * from cdsongs where songid = ftss_results() ;
> ERROR:  Set-valued function called in context that cannot accept a set

'=' is a scalar operation.  Try

select * from cdsongs where songid IN (select ftss_results());
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: C++ Headers
Next
From: Tom Lane
Date:
Subject: Re: Fix for tablename in targetlist