IntroductiontoPL/pgSQL
EXECUTE sql INTO v_count; RETURN v_count; END $$ LANGUAGE plpgsql; Note:Donotdothis.Validatetheparametersfirst. ExecuteUsing CREATE FUNCTION get_connection_count(p_role varchar) RETURNS integer AS $$ DECLARE v_count integer; sql varchar; BEGIN sql := 'SELECT count(*) FROM pg_stat_activity WHERE usename = $1'; EXECUTE sql INTO … ................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- advanced access to postgresql from python with psycopg2
- taking advantage of the proc sql pass through facility
- python postgresql tutorial
- setting up postgresql
- postgresql functions by example
- ecpg postgresql embedded sql c precompiler
- managing rights in postgresql
- postgresql psql shell commands tutorial kart
- introductiontopl pgsql