Sha256: 04a4cf770fe4821e1fe5c463a204b419243b1804342cb433310c00b029adb677
Contents?: true
Size: 472 Bytes
Versions: 12
Compression:
Stored size: 472 Bytes
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
12 entries across 12 versions & 1 rubygems