Mercurial > hg > dotemacs

view elpa/sql-indent-1.4/test-data/pr81.sql @ 198:542bdd6b7739

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
sql-indent: replace with newer ELPA version
author Jordi Gutiérrez Hermoso <jordigh@octave.org>
date Sun, 08 Dec 2019 14:39:27 -0500
parents
children
line wrap: on
line source

IF (SELECT ID
      FROM SomeTable
     WHERE SomeField > 0) IS NULL
THEN
  SET SomeVar = TRUE;
ELSIF
  SET SomeVar = FALSE;
END IF;

IF (SELECT ID
      FROM SomeTable
     WHERE SomeField > 0) IS NULL
THEN
  SET SomeVar = TRUE;
ELSEIF
  SET SomeVar = FALSE;
END IF;