* 字符必须使用单引号，双引号会解析成字段名 #### -- 可视化管理工具 1.pgAdmin4 for newest PostgreSQL version 2.phpPgAdmin 3.2 for old PostgreSQL version #### -- 区间分段查询 ~~~ SELECT member_id,case when (age between (0)::numeric and(24)::numeric) then '25岁以下'::text when (age between (25)::numeric and(29)::numeric) then '25-29岁'::text when (age between (30)::numeric and(34)::numeric) then '30-34岁'::text when (age between (35)::numeric and(39)::numeric) then '35-39岁'::text when (age between (40)::numeric and(44)::numeric) then '40-44岁'::text when (age between (45)::numeric and(49)::numeric) then '45-49岁'::text when (age between (50)::numeric and(54)::numeric) then '50-54岁'::text when (age between (55)::numeric and(120)::numeric) then '55岁及以上'::text else '未知'::text end as age_level FROM td_user_profile_part ~~~