| From: | Vadim Mikheev <vadim(at)krs(dot)ru> |
|---|---|
| To: | Jan Wieck <jwieck(at)debis(dot)com> |
| Cc: | s-fery(at)kkt(dot)sote(dot)hu, pgsql-sql(at)postgreSQL(dot)org, hackers(at)postgreSQL(dot)org |
| Subject: | Re: [SQL] cursor and update + view |
| Date: | 1998-11-24 10:33:29 |
| Message-ID: | 365A8B79.31DC53FA@krs.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-sql |
Jan Wieck wrote:
>
> > My other problem is with the views: it seems not work if there is an
> > aggregate command in the SELECT. It's only my experience, or others
> > noticed it also? (The details are on the pgsql-novice (subject: view
> > and aggregate command problem))
>
> Aggregates in view's are still buggy. It is possible to
> change the grouping when doing a join from such a view and
> another relation in a way, that crashes the backend.
We'll have to implement subqueries in FROM someday - this would
allow handle aggregates in views...
Vadim
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Wieck | 1998-11-24 12:04:57 | Re: [HACKERS] Re: [SQL] cursor and update + view |
| Previous Message | Lendvary Gyorgy | 1998-11-24 10:13:58 | createdb problem |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Herouth Maoz | 1998-11-24 11:27:30 | Re: [SQL] select in update |
| Previous Message | Engard Ferenc | 1998-11-24 10:05:27 | Re: [SQL] select in update |