Where is a mistake?

Поиск
Список
Период
Сортировка
От Alexandr Listopad
Тема Where is a mistake?
Дата
Msg-id Pine.BSF.4.10.10005261724210.27113-100000@Eagle.ZGIA.zp.ua
обсуждение исходный текст
Список pgsql-interfaces
CREATE VIEW v1 AS SELECT n.net AS net,                       n.sh_desc AS net_name,                       count(s.ip)
AStotal_q        sum(s.bytes)/1024 AS Kb                       FROM zgia_nets n,                       squid_logs s
                 WHERE network_sub(s.ip,n.net)                       AND
date_eq(dt::date,'24-05-2000')                      AND                       s.peer_stat != 'NONE'
 GROUP BY net,net_name                       ORDER BY Kb;
 

stats=> select t1.net,t1.net_name,t1.total_q,t1.total_q/sum(t2.total_q) from v1 t1,
v1 t2 group by 1,2,3;

pqReadData() -- backend closed the channel unexpectedly.       This probably means the backend terminated abnormally
  before or while processing the request.
 
We have lost the connection to the backend, so further processing is
impossible.  Terminating.


where is a mistake? or is it a bug?

I have PGSQL v 6.5.3.


--Laa.



В списке pgsql-interfaces по дате отправления:

Предыдущее
От: Herbert Rabago Ambos
Дата:
Сообщение: Re: importing from other dbases
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Postgresql 7.0 JDBC exceptions - broken connections ?