From: | Vikrant Rathore <vikrant(at)chemquick(dot)com> |
---|---|
To: | pgsql-sql(at)hub(dot)org |
Subject: | Mail about select |
Date: | 1999-06-04 08:01:31 |
Message-ID: | 375787DB.65CCEF22@chemquick.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Martin Leja | 1999-06-04 10:45:22 | Howto convert floats to text? |
Previous Message | Oliver Elphick | 1999-06-04 07:41:52 | Re: [SQL] Group By Dilemma |