From: Vikrant Rathore <vikrant@chemquick.com>
To: pgsql-sql@hub.org
Subject: Mail about select
Date: Fri, 04 Jun 1999 16:01:31 +0800
Message-ID: <375787DB.65CCEF22@chemquick.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: vikrant@chemquick.com, pgsql-sql@hub.org
Subject: Re: Mail about select
In-Reply-To: <375787DB.65CCEF22@chemquick.com>
References: <375787DB.65CCEF22@chemquick.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox