File: 900_create_view.sql

package info (click to toggle)
sqlfmt 0.29.0-1
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 1,580 kB
  • sloc: python: 10,007; sql: 5,626; makefile: 39
file content (6 lines) | stat: -rw-r--r-- 228 bytes parent folder | download 
1
2
3
4
5
6
 
-- source: https://github.com/tconbeer/sqlfmt/issues/395
-- for now this should no-op
CREATE OR REPLACE VIEW someview AS (
WITH some_cte AS (SELECT CASE WHEN foo = bar THEN 1 ELSE 0 END AS biz FROM BAT)
select * from some_cte
)