| From: | "Florian G(dot) Pflug" <fgp(at)phlo(dot)org> |
|---|---|
| To: | pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org> |
| Subject: | Bug regarding update.. from and aggregates ? |
| Date: | 2005-06-17 14:09:10 |
| Message-ID: | 42B2D986.9020909@phlo.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-hackers |
Hi
When executing the following statements:
create schema bugtest ;
drop table bugtest.t1 ;
drop table bugtest.t2 ;
create table bugtest.t1(id int4, maximum int4, dummy int4) ;
create table bugtest.t2(id int4, entry int4) ;
insert into bugtest.t1 (id) values (1) ;
insert into bugtest.t1 (id) values (2) ;
insert into bugtest.t2 (id, entry) values (1, 1) ;
insert into bugtest.t2 (id, entry) values (1, 2) ;
insert into bugtest.t2 (id, entry) values (2, 3) ;
insert into bugtest.t2 (id, entry) values (2, 4) ;
update bugtest.t1 set maximum = max(t2.entry) from bugtest.t2
where t1.id = t2.id ;
The last update given "One row affected" - and indeed, t1 looks
like this after the update:
id | maximum
1 | 4
2 | <NULL>
While I would expect:
id | maximum
1 | 2
2 | 4
Is this I bug, or is the observed behaviour actually intended?
greetings, Florian Pflug
| From | Date | Subject | |
|---|---|---|---|
| Next Message | svn | 2005-06-17 14:24:43 | SVN Commit by andreas: r4311 - trunk/pgadmin3/xtra/pgagent |
| Previous Message | svn | 2005-06-17 13:03:40 | SVN Commit by andreas: r4310 - trunk/pgadmin3/src/dlg |