From: | wd <wd(at)wdicc(dot)com> |
---|---|
To: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | Group by bug? |
Date: | 2012-12-28 07:24:23 |
Message-ID: | CABexzmhtmwdYFyhDAXWsqHf60ZQrJvshrdzX0t1G6g7KcB3G2w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
hi,
wd_test=# \d t1
Table "public.t1"
Column | Type | Modifiers
--------+---------+-------------------------------------------------
id | integer | not null default nextval('t1_id_seq'::regclass)
tag | text |
wd_test=# select * from t1;
id | tag
----+-----
1 | a
2 | a
3 | b
4 | c
5 | b
(5 rows)
---- this sql will not group by the case result.
wd_test=# select case t1.tag when 'a' then '1' else '0' end as tag,
count(*) from t1 group by tag;
tag | count
-----+-------
0 | 1
0 | 2
1 | 2
(3 rows)
---- this sql will group by the case result.
wd_test=# select case t1.tag when 'a' then '1' else '0' end as ttag,
count(*) from t1 group by ttag;
ttag | count
------+-------
0 | 3
1 | 2
(2 rows)
From | Date | Subject | |
---|---|---|---|
Next Message | wd | 2012-12-28 07:26:00 | Re: Group by bug? |
Previous Message | nevillekb | 2012-12-28 06:52:36 | Tool to create database diagrams in postgreSQL |