Re: [SQL] Mail about select

Vikrant Rathore <vikrant@chemquick.com> writes:
> now i am firing a query like this:

> select r.uname from radius r, radiustemp rt where r.uname<>rt.uname and
> r.logdate<>rt.logdate and r.logtime<>rt.logtime;

> After some time i get  response
> "Segmentation Error"
> core(sumped)

How big are your tables?  That query will probably produce an output
row for almost every combination of a row from radius with a row from
radiustemp, which might overflow the allowed memory for your
application.

I suppose what you really want is to find the rows in radius that do
not have duplicates in radiustemp, but that query won't do it...
        regards, tom lane