union 사용하다가 실패를 했는데 아래 방법이 되더군요..
한테이블에서 년령대별/성별 가입자수를 가져오는 query 문입니다.
$sqlstr = "select (select count(uid) from wiz_statistic where age <= 19 and gender = 1) as man10,
(select count(uid) from wiz_statistic where age <= 19 and gender = 2) as woman10,
(select count(uid) from wiz_statistic where age between 20 and 29 and gender = 1) as man20,
(select count(uid) from wiz_statistic where age between 20 and 29 and gender = 2) as woman20,
(select count(uid) from wiz_statistic where age between 30 and 39 and gender = 1) as man30,
(select count(uid) from wiz_statistic where age between 30 and 39 and gender = 2) as woman30,
(select count(uid) from wiz_statistic where age between 40 and 49 and gender = 1) as man40,
(select count(uid) from wiz_statistic where age between 40 and 49 and gender = 2) as woman40,
(select count(uid) from wiz_statistic where age >= 50 and gender = 1) as man50,
(select count(uid) from wiz_statistic where age >= 50 and gender = 2) as woman50
";
//$sqlstr = "select * from (select count(*) as man20 from wiz_statistic where age between 20 and 29 and gender = 1) union all (select count(*) as woman20 from wiz_statistic where age between 20 and 29 and gender = 2)";
//$sqlstr = "select (select count(*) from wiz_statistic where age between 20 and 29 and gender = 1) as man20, (select count(*) from wiz_statistic where age between 20 and 29 and gender = 2) as woman20";
$sqlqry = pg_exec($sqlstr) or die(pg_result_error());
$list = pg_fetch_array($sqlqry) or die(pg_result_error());