Contents

-- this is a SQL comment

select 1;

select 2;

select
3;

create table emp(id BIGSERIAL PRIMARY KEY, name varchar(255));

-- a sql function
CREATE FUNCTION clean_emp() RETURNS void AS '
    DELETE FROM emp;
' LANGUAGE SQL;

-- a sql function on one line
CREATE FUNCTION clean_emp2() RETURNS void AS 'DELETE FROM emp;' LANGUAGE SQL;

CREATE FUNCTION populate() RETURNS integer AS $$
DECLARE
    -- declarations
BEGIN
    PERFORM clean_emp2();
END;
$$ LANGUAGE plpgsql;

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
pg_migrate-0.1.11	spec/pg_migrate/input_manifests/single_manifest/up/single1.sql