Mail about select

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

Browse pgsql-sql by date

  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