From: | Rafal Pietrak <rafal(at)zorro(dot)isa-geek(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: a row disapearing |
Date: | 2006-05-27 19:06:16 |
Message-ID: | 1148756777.14902.38.camel@model.home.waw.pl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sat, 2006-05-27 at 11:51 -0700, Richard Broersma Jr wrote:
> select count(xxx.id) as cnt,
> xxx.id,
> xxx_grp.id as grpid,
> xxx_grp.grp
> from xxx
> right join xxx_grp
> on (xxx.id = xxx_grp.id)
> group by xxx.id, grpid, xxx_grp.grp
> order by xxx_grp.id;
>
> cnt | id | grpid | grp
> -----+----+-------+--------
> 0 | | 0 | group0
> 1 | 1 | 1 | group1
> 2 | 2 | 2 | group2
The count() in my case may easyly reach 10k (so the group table wont end
up too light, and it have to have a margin), but that's something
concrete to start with.
Thenx.
--
-R
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Smith | 2006-05-27 19:13:19 | Per session variables |
Previous Message | Eric Montague | 2006-05-27 18:57:14 | Re: psql: krb5_sendauth: Bad application version was sent |