From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | a2891891(at)smail(dot)Uni-Koeln(dot)DE (Viktor A(dot)) |
Cc: | pgsql-sql(at)postgreSQL(dot)org |
Subject: | Re: [SQL] Backend closes caused by query on a view?! |
Date: | 1999-03-13 16:06:04 |
Message-ID: | 199903131606.LAA10029@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
[Charset iso-8859-1 unsupported, filtering to ASCII...]
> Hi!
>
> Can anybody tell me, what I'm doing so wrong,
> that the backend needs to close the connection?
> I've got a view that gives me a total of costs for
> each day, which looks like this:
>
> create view view_test AS
> select date(datum_zeit),sum(betrag) AS "summe"
> from anrufe_isdn where richtung='True'
> AND date(datum_zeit)>date(timemi(now() ::datetime, '30 day' ::timespan))
> group by date(datum_zeit);
We have some problems with aggregates in views, I think.
The TODO list says:
* views containing aggregates sometimes fail(Jan)
--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Clark Evans | 1999-03-13 16:19:13 | OT: Modeling Tools |
Previous Message | Viktor A. | 1999-03-13 09:54:36 | Backend closes caused by query on a view?! |