Skip site navigation (1) Skip section navigation (2)

Re: [SQL] cursor and update + view

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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

In response to

Responses

pgsql-hackers by date

Next:From: Jan WieckDate: 1998-11-24 12:04:57
Subject: Re: [HACKERS] Re: [SQL] cursor and update + view
Previous:From: Lendvary GyorgyDate: 1998-11-24 10:13:58
Subject: createdb problem

pgsql-sql by date

Next:From: Herouth MaozDate: 1998-11-24 11:27:30
Subject: Re: [SQL] select in update
Previous:From: Engard FerencDate: 1998-11-24 10:05:27
Subject: Re: [SQL] select in update

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group