Received: from chemquick.com (root@[202.170.29.67]) by hub.org (8.9.3/8.9.3) with ESMTP id DAA48428 for ; Fri, 4 Jun 1999 03:58:23 -0400 (EDT) (envelope-from vikrant@chemquick.com) Received: from chemquick.com ([202.170.29.126]) by chemquick.com (8.8.7/8.8.7) with ESMTP id PAA18690 for ; Fri, 4 Jun 1999 15:52:38 +0800 Message-ID: <375787DB.65CCEF22@chemquick.com> Date: Fri, 04 Jun 1999 16:01:31 +0800 From: Vikrant Rathore Reply-To: vikrant@chemquick.com Organization: NeuroNet X-Mailer: Mozilla 4.6 [en] (Win98; I) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@hub.org Subject: Mail about select Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Dear Friends, I have two tables 1. "Radius" Table = radius +----------------------------------+----------------------------------+-------+ | Field | Type | Length| +----------------------------------+----------------------------------+-------+ | uname | char() | 256 | | logdate | date | 4 | | logtime | time | 8 | | duration | int4 | 4 | | status | char() | 20 | | nasadd | char() | 20 | | port | int4 | 4 | | bytesin | int4 | 4 | | bytesout | int4 | 4 | | packin | int4 | 4 | | packout | int4 | 4 | | misc | int4 | 4 | +----------------------------------+--------------------------------- 2) "radiustemp" with the same structure 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) can any one help what is the error in this query. Thanks in advance for your kind help. Regards, Vikrant