Mail about select
От | Vikrant Rathore |
---|---|
Тема | Mail about select |
Дата | |
Msg-id | 375787DB.65CCEF22@chemquick.com обсуждение исходный текст |
Ответы |
Re: [SQL] Mail about select
|
Список | 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
В списке pgsql-sql по дате отправления: