質問編集履歴

タグ追加。SQLの修正。

2018/12/12 07:58

投稿

スコア16

title CHANGED Viewed

File without changes

body CHANGED Viewed

@@ -24,21 +24,21 @@
 ```Postgresql
 DECLARE
-w_flag BOOLEAN := FALSE;
+  w_flag BOOLEAN := FALSE;
 BEGIN
-  RETURN QUERY
+RETURN QUERY
   SELECT
     *
   WHERE
     some_table as t1
-　ORDER BY
+  ORDER BY
     CASE WHEN w_flag THEN t1.id ASC, t1.name DESC
     ELSE
       t1.name DESC, t1.name DESC
-    END;
+    END
   OFFSET 0
   LIMIT 20
-  ;
+;
 END;
 $FUNCTION$ LANGUAGE plpgsql;