AW: Re: External search engine, advice

From: Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at>
To: "'Andrew McMillan'" <andrew(at)catalyst(dot)net(dot)nz>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Hackers List <pgsql-hackers(at)postgresql(dot)org>
Subject: AW: Re: External search engine, advice
Date: 2001-05-21 15:39:11
Message-ID: 11C1E6749A55D411A9670001FA6879633682DE@sdexcsrv1.f000.d0188.sd.spardat.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> Tom Lane wrote:
> >
> > begin;
> > select * from foo where x = functhatreadsbar();

I thought that the per statement way to do it with a non cacheable function was:
select * from foo where x = (select functhatreadsbar());

??
Andreas

PS: an iscacheable function without arguments is imho a funny construct anyways.

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-05-21 15:47:54 Re: AW: Fix for tablename in targetlist
Previous Message Peter Eisentraut 2001-05-21 15:35:32 Detecting readline in configure