Re: Re: External search engine, advice

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: mlw <markw(at)mohawksoft(dot)com>
Cc: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Re: External search engine, advice
Date: 2001-05-19 15:28:33
Message-ID: 229.990286113@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

mlw <markw(at)mohawksoft(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-05-19 15:33:38 Re: Fix for tablename in targetlist
Previous Message Tom Lane 2001-05-19 15:26:29 Re: C++ Headers