Annotation: scrud.parse_default

CREATE OR REPLACE FUNCTION scrud.parse_default(text)
RETURNS text

Information: scrud.parse_default

Schema	scrud
Function Name	parse_default
Arguments	text
Owner	postgres
Result Type	text
Description	Parses default constraint column values.

Implementation: scrud.parse_default

CREATE OR REPLACE FUNCTION scrud.parse_default(text)
 RETURNS text
 LANGUAGE plpgsql
AS $function$
DECLARE _sql text;
DECLARE _val text;
BEGIN
    IF($1 LIKE '%::%' AND $1 NOT LIKE 'nextval%') THEN
        _sql := 'SELECT ' || $1;
        EXECUTE _sql INTO _val;
        RETURN _val;
    END IF;

    RETURN $1;
END
$function$