diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2006-02-27 16:09:50 +0000 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2006-02-27 16:09:50 +0000 |
| commit | 7f4f42fa100872507ca10d8e0f7d923acc266ee8 (patch) | |
| tree | c297cd70679cb60b470f8199ab707d80de108d5c /contrib/dblink | |
| parent | fe83b3ebc6b8d65fbb14100bdc476b7dbc32454c (diff) | |
| download | postgresql-7f4f42fa100872507ca10d8e0f7d923acc266ee8.tar.gz | |
Clean up CREATE FUNCTION syntax usage in contrib and elsewhere, in
particular get rid of single quotes around language names and old WITH ()
construct.
Diffstat (limited to 'contrib/dblink')
| -rw-r--r-- | contrib/dblink/dblink.sql.in | 100 |
1 files changed, 50 insertions, 50 deletions
diff --git a/contrib/dblink/dblink.sql.in b/contrib/dblink/dblink.sql.in index c38f8be888..7cd705ba54 100644 --- a/contrib/dblink/dblink.sql.in +++ b/contrib/dblink/dblink.sql.in @@ -1,146 +1,146 @@ CREATE OR REPLACE FUNCTION dblink_connect (text) RETURNS text AS 'MODULE_PATHNAME','dblink_connect' -LANGUAGE 'C' STRICT; +LANGUAGE C STRICT; CREATE OR REPLACE FUNCTION dblink_connect (text, text) RETURNS text AS 'MODULE_PATHNAME','dblink_connect' -LANGUAGE 'C' STRICT; +LANGUAGE C STRICT; CREATE OR REPLACE FUNCTION dblink_disconnect () RETURNS text AS 'MODULE_PATHNAME','dblink_disconnect' -LANGUAGE 'C' STRICT; +LANGUAGE C STRICT; CREATE OR REPLACE FUNCTION dblink_disconnect (text) RETURNS text AS 'MODULE_PATHNAME','dblink_disconnect' -LANGUAGE 'C' STRICT; +LANGUAGE C STRICT; -CREATE OR REPLACE FUNCTION dblink_open (text,text) +CREATE OR REPLACE FUNCTION dblink_open (text, text) RETURNS text AS 'MODULE_PATHNAME','dblink_open' -LANGUAGE 'C' STRICT; +LANGUAGE C STRICT; -CREATE OR REPLACE FUNCTION dblink_open (text,text,bool) +CREATE OR REPLACE FUNCTION dblink_open (text, text, boolean) RETURNS text AS 'MODULE_PATHNAME','dblink_open' -LANGUAGE 'C' STRICT; +LANGUAGE C STRICT; -CREATE OR REPLACE FUNCTION dblink_open (text,text,text) +CREATE OR REPLACE FUNCTION dblink_open (text, text, text) RETURNS text AS 'MODULE_PATHNAME','dblink_open' -LANGUAGE 'C' STRICT; +LANGUAGE C STRICT; -CREATE OR REPLACE FUNCTION dblink_open (text,text,text,bool) +CREATE OR REPLACE FUNCTION dblink_open (text, text, text, boolean) RETURNS text AS 'MODULE_PATHNAME','dblink_open' -LANGUAGE 'C' STRICT; +LANGUAGE C STRICT; -CREATE OR REPLACE FUNCTION dblink_fetch (text,int) +CREATE OR REPLACE FUNCTION dblink_fetch (text, int) RETURNS setof record AS 'MODULE_PATHNAME','dblink_fetch' -LANGUAGE 'C' STRICT; +LANGUAGE C STRICT; -CREATE OR REPLACE FUNCTION dblink_fetch (text,int,bool) +CREATE OR REPLACE FUNCTION dblink_fetch (text, int, boolean) RETURNS setof record AS 'MODULE_PATHNAME','dblink_fetch' -LANGUAGE 'C' STRICT; +LANGUAGE C STRICT; -CREATE OR REPLACE FUNCTION dblink_fetch (text,text,int) +CREATE OR REPLACE FUNCTION dblink_fetch (text, text, int) RETURNS setof record AS 'MODULE_PATHNAME','dblink_fetch' -LANGUAGE 'C' STRICT; +LANGUAGE C STRICT; -CREATE OR REPLACE FUNCTION dblink_fetch (text,text,int,bool) +CREATE OR REPLACE FUNCTION dblink_fetch (text, text, int, boolean) RETURNS setof record AS 'MODULE_PATHNAME','dblink_fetch' -LANGUAGE 'C' STRICT; +LANGUAGE C STRICT; CREATE OR REPLACE FUNCTION dblink_close (text) RETURNS text AS 'MODULE_PATHNAME','dblink_close' -LANGUAGE 'C' STRICT; +LANGUAGE C STRICT; -CREATE OR REPLACE FUNCTION dblink_close (text,bool) +CREATE OR REPLACE FUNCTION dblink_close (text, boolean) RETURNS text AS 'MODULE_PATHNAME','dblink_close' -LANGUAGE 'C' STRICT; +LANGUAGE C STRICT; -CREATE OR REPLACE FUNCTION dblink_close (text,text) +CREATE OR REPLACE FUNCTION dblink_close (text, text) RETURNS text AS 'MODULE_PATHNAME','dblink_close' -LANGUAGE 'C' STRICT; +LANGUAGE C STRICT; -CREATE OR REPLACE FUNCTION dblink_close (text,text,bool) +CREATE OR REPLACE FUNCTION dblink_close (text, text, boolean) RETURNS text AS 'MODULE_PATHNAME','dblink_close' -LANGUAGE 'C' STRICT; +LANGUAGE C STRICT; -CREATE OR REPLACE FUNCTION dblink (text,text) +CREATE OR REPLACE FUNCTION dblink (text, text) RETURNS setof record AS 'MODULE_PATHNAME','dblink_record' -LANGUAGE 'C' STRICT; +LANGUAGE C STRICT; -CREATE OR REPLACE FUNCTION dblink (text,text,bool) +CREATE OR REPLACE FUNCTION dblink (text, text, boolean) RETURNS setof record AS 'MODULE_PATHNAME','dblink_record' -LANGUAGE 'C' STRICT; +LANGUAGE C STRICT; CREATE OR REPLACE FUNCTION dblink (text) RETURNS setof record AS 'MODULE_PATHNAME','dblink_record' -LANGUAGE 'C' STRICT; +LANGUAGE C STRICT; -CREATE OR REPLACE FUNCTION dblink (text,bool) +CREATE OR REPLACE FUNCTION dblink (text, boolean) RETURNS setof record AS 'MODULE_PATHNAME','dblink_record' -LANGUAGE 'C' STRICT; +LANGUAGE C STRICT; -CREATE OR REPLACE FUNCTION dblink_exec (text,text) +CREATE OR REPLACE FUNCTION dblink_exec (text, text) RETURNS text AS 'MODULE_PATHNAME','dblink_exec' -LANGUAGE 'C' STRICT; +LANGUAGE C STRICT; -CREATE OR REPLACE FUNCTION dblink_exec (text,text,bool) +CREATE OR REPLACE FUNCTION dblink_exec (text, text, boolean) RETURNS text AS 'MODULE_PATHNAME','dblink_exec' -LANGUAGE 'C' STRICT; +LANGUAGE C STRICT; CREATE OR REPLACE FUNCTION dblink_exec (text) RETURNS text AS 'MODULE_PATHNAME','dblink_exec' -LANGUAGE 'c' STRICT; +LANGUAGE C STRICT; -CREATE OR REPLACE FUNCTION dblink_exec (text,bool) +CREATE OR REPLACE FUNCTION dblink_exec (text,boolean) RETURNS text AS 'MODULE_PATHNAME','dblink_exec' -LANGUAGE 'c' STRICT; +LANGUAGE C STRICT; -CREATE TYPE dblink_pkey_results AS (position int4, colname text); +CREATE TYPE dblink_pkey_results AS (position int, colname text); CREATE OR REPLACE FUNCTION dblink_get_pkey (text) RETURNS setof dblink_pkey_results AS 'MODULE_PATHNAME','dblink_get_pkey' -LANGUAGE 'c' STRICT; +LANGUAGE C STRICT; -CREATE OR REPLACE FUNCTION dblink_build_sql_insert (text, int2vector, int4, _text, _text) +CREATE OR REPLACE FUNCTION dblink_build_sql_insert (text, int2vector, int, _text, _text) RETURNS text AS 'MODULE_PATHNAME','dblink_build_sql_insert' -LANGUAGE 'C' STRICT; +LANGUAGE C STRICT; -CREATE OR REPLACE FUNCTION dblink_build_sql_delete (text, int2vector, int4, _text) +CREATE OR REPLACE FUNCTION dblink_build_sql_delete (text, int2vector, int, _text) RETURNS text AS 'MODULE_PATHNAME','dblink_build_sql_delete' -LANGUAGE 'C' STRICT; +LANGUAGE C STRICT; -CREATE OR REPLACE FUNCTION dblink_build_sql_update (text, int2vector, int4, _text, _text) +CREATE OR REPLACE FUNCTION dblink_build_sql_update (text, int2vector, int, _text, _text) RETURNS text AS 'MODULE_PATHNAME','dblink_build_sql_update' -LANGUAGE 'C' STRICT; +LANGUAGE C STRICT; CREATE OR REPLACE FUNCTION dblink_current_query () RETURNS text AS 'MODULE_PATHNAME','dblink_current_query' -LANGUAGE 'C'; +LANGUAGE C; |
