From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | vikrant(at)chemquick(dot)com |
Cc: | pgsql-sql(at)hub(dot)org |
Subject: | Re: [SQL] Mail about select |
Date: | 1999-06-04 14:33:18 |
Message-ID: | 16871.928506798@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Vikrant Rathore <vikrant(at)chemquick(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | José Soares | 1999-06-04 14:51:58 | Re: [SQL] datetime function |
Previous Message | Tom Lane | 1999-06-04 14:21:53 | Re: [SQL] Slashdot Query |