Where is a mistake?

From: Alexandr Listopad <laa(at)laa(dot)zp(dot)ua>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Where is a mistake?
Date: 2000-05-26 14:31:00
Message-ID: Pine.BSF.4.10.10005261724210.27113-100000@Eagle.ZGIA.zp.ua
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces


CREATE VIEW v1 AS SELECT n.net AS net,
n.sh_desc AS net_name,
count(s.ip) AS total_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.

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Tom Lane 2000-05-26 15:13:16 Re: Postgresql 7.0 JDBC exceptions - broken connections ?
Previous Message Gunnar R|nning 2000-05-26 09:36:38 Re: Postgresql 7.0 JDBC exceptions - broken connecti ons ?