Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TYPE situacaobool AS ENUM ('Ativo', 'Inativo'); -- (TRUE=Ativo, FALSE=Inativo)
- CREATE TYPE situacaoint AS ENUM ('Ativo', 'Inativo'); -- (1=Ativo, 0=Inativo)
- CREATE OR REPLACE FUNCTION bool2situacao(boolean)
- RETURNS situacaobool AS $$
- BEGIN
- RETURN CASE WHEN $1 THEN 'Ativo'::situacaobool ELSE 'Inativo'::situacaobool END;
- END;
- $$ LANGUAGE plpgsql IMMUTABLE;
- CREATE OR REPLACE FUNCTION int2situacao(integer)
- RETURNS situacaoint AS $$
- BEGIN
- RETURN CASE WHEN $1 = 1 THEN 'Ativo'::situacaoint ELSE 'Inativo'::situacaoint END;
- END;
- $$ LANGUAGE plpgsql IMMUTABLE;
- CREATE CAST (boolean AS situacaobool) WITH FUNCTION bool2situacao(boolean) AS IMPLICIT;
- CREATE CAST (integer AS situacaoint) WITH FUNCTION int2situacao(integer) AS IMPLICIT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
