On Mon, Dec 15, 2003 at 12:14:17 -0500,
Prashant Dalal <[EMAIL PROTECTED]> wrote:
> Hi,
>
> My Following select st. is running from last one day. I think the problem is
> NOT IN clause.
> Please suggest the alternative select clause.
NOT IN was especially slow up until Postgres 7.4. If using 7.
Hi,
My Following select st. is running from last one day. I think the problem is
NOT IN clause.
Please suggest the alternative select clause.
SELECT resreq.proj, resreq.ver, substr(resreq.act, -5, 5) act, resreq.rn,
null,
null, resreq.rl, resreq.dr, resreq.ra
FROM resreq
WHERE r
