Skip to content

Instantly share code, notes, and snippets.

@RoxasShadow

RoxasShadow/psql_bool_to_int.sql

Created January 22, 2014 00:22
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save RoxasShadow/8551260 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save RoxasShadow/8551260 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
psql_bool_to_int.sql
ALTER TABLE episodes ALTER editing SET DEFAULT null;
ALTER TABLE episodes
ALTER editing TYPE smallint
USING
CASE
WHEN editing THEN 2 else 1
END;
ALTER TABLE episodes ALTER editing SET DEFAULT 1;
COMMIT;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment