File: case.sql

package info (click to toggle)
libpg-query 17-6.2.1-1
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 33,436 kB
  • sloc: ansic: 175,860; sql: 79,564; ruby: 1,605; makefile: 281; cpp: 221
file content (7 lines) | stat: -rw-r--r-- 212 bytes parent folder | download | duplicates (4) 
1
2
3
4
5
6
7
 
SELECT
    CASE
        WHEN count(*) FILTER (WHERE col_state = 2) = count(col_id) THEN true
        WHEN count(*) FILTER (WHERE col_state = 3) > 0 THEN false
        ELSE NULL
    END AS col_alias
FROM my_table