List Redshift procedures as functions #2278
Description
Description
HeidiSQL version
12.12.0.7135
Database server version
PostgreSQL 8.0.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.2 20041017 (Red Hat 3.4.2-6.fc3), Redshift 1.0.127211
Reproduction recipe
Running from Amazon Redshift query editor v2 (web interface):
CREATE OR REPLACE PROCEDURE public.sp_add_numbers_redshift(
IN a INTEGER,
IN b INTEGER
)
AS $$
DECLARE
result INTEGER;
BEGIN
result := a + b;
END;
$$ LANGUAGE plpgsql;
SELECT
p.proname
FROM
pg_catalog.pg_namespace n
JOIN pg_catalog.pg_proc p ON
pronamespace = n.oid
WHERE
n.nspname in ('public') AND p.proname LIKE 'sp%';
proname
sp_add_numbers_redshift