From 8b4c798973033156db58dbca3b605e1045cc587d Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Thu, 4 Jul 2013 11:33:08 -0400 Subject: [PATCH] Add contrib function references in the doc index Backpatch to 9.3. Idea from Craig Ringer --- doc/src/sgml/dblink.sgml | 76 ++++++++++++++++++++++++++++ doc/src/sgml/earthdistance.sgml | 16 +++--- doc/src/sgml/fuzzystrmatch.sgml | 28 +++++++++++ doc/src/sgml/hstore.sgml | 30 +++++------ doc/src/sgml/intagg.sgml | 12 +++++ doc/src/sgml/intarray.sgml | 16 +++--- doc/src/sgml/isn.sgml | 6 +-- doc/src/sgml/ltree.sgml | 14 +++--- doc/src/sgml/pageinspect.sgml | 21 ++++++++ doc/src/sgml/pgbuffercache.sgml | 4 ++ doc/src/sgml/pgcrypto.sgml | 80 +++++++++++++++++++++++++++++ doc/src/sgml/pgfreespacemap.sgml | 3 ++ doc/src/sgml/pgrowlocks.sgml | 4 ++ doc/src/sgml/pgstatstatements.sgml | 4 ++ doc/src/sgml/pgstattuple.sgml | 13 +++++ doc/src/sgml/pgtrgm.sgml | 8 +-- doc/src/sgml/sslinfo.sgml | 81 ++++++++++++++++++++---------- doc/src/sgml/tablefunc.sgml | 21 ++++++++ doc/src/sgml/uuid-ossp.sgml | 6 +-- doc/src/sgml/xml2.sgml | 8 +++ 20 files changed, 376 insertions(+), 75 deletions(-) diff --git a/doc/src/sgml/dblink.sgml b/doc/src/sgml/dblink.sgml index 4bf65c67b1..a26e378678 100644 --- a/doc/src/sgml/dblink.sgml +++ b/doc/src/sgml/dblink.sgml @@ -29,6 +29,10 @@ opens a persistent connection to a remote database + + dblink_connect + + dblink_connect(text connstr) returns text @@ -189,6 +193,10 @@ DROP SERVER fdtest; opens a persistent connection to a remote database, insecurely + + dblink_connect_u + + dblink_connect_u(text connstr) returns text @@ -242,6 +250,10 @@ dblink_connect_u(text connname, text connstr) returns text closes a persistent connection to a remote database + + dblink_disconnect + + dblink_disconnect() returns text @@ -313,6 +325,10 @@ SELECT dblink_disconnect('myconn'); executes a query in a remote database + + dblink + + dblink(text connname, text sql [, bool fail_on_error]) returns setof record @@ -527,6 +543,10 @@ SELECT * FROM dblink('myconn', 'select proname, prosrc from pg_proc') executes a command in a remote database + + dblink_exec + + dblink_exec(text connname, text sql [, bool fail_on_error]) returns text @@ -660,6 +680,10 @@ DETAIL: ERROR: null value in column "relnamespace" violates not-null constrain opens a cursor in a remote database + + dblink_open + + dblink_open(text cursorname, text sql [, bool fail_on_error]) returns text @@ -780,6 +804,10 @@ SELECT dblink_open('foo', 'select proname, prosrc from pg_proc'); returns rows from an open cursor in a remote database + + dblink_fetch + + dblink_fetch(text cursorname, int howmany [, bool fail_on_error]) returns setof record @@ -929,6 +957,10 @@ SELECT * FROM dblink_fetch('foo', 5) AS (funcname name, source text); closes a cursor in a remote database + + dblink_close + + dblink_close(text cursorname [, bool fail_on_error]) returns text @@ -1036,6 +1068,10 @@ SELECT dblink_close('foo'); returns the names of all open named dblink connections + + dblink_get_connections + + dblink_get_connections() returns text[] @@ -1077,6 +1113,10 @@ SELECT dblink_get_connections(); gets last error message on the named connection + + dblink_error_message + + dblink_error_message(text connname) returns text @@ -1136,6 +1176,10 @@ SELECT dblink_error_message('dtest1'); sends an async query to a remote database + + dblink_send_query + + dblink_send_query(text connname, text sql) returns int @@ -1214,6 +1258,10 @@ SELECT dblink_send_query('dtest1', 'SELECT * FROM foo WHERE f1 < 3'); checks if connection is busy with an async query + + dblink_is_busy + + dblink_is_busy(text connname) returns int @@ -1273,6 +1321,10 @@ SELECT dblink_is_busy('dtest1'); retrieve async notifications on a connection + + dblink_get_notify + + dblink_get_notify() returns setof (notify_name text, be_pid int, extra text) @@ -1351,6 +1403,10 @@ SELECT * FROM dblink_get_notify(); gets an async query result + + dblink_get_result + + dblink_get_result(text connname [, bool fail_on_error]) returns setof record @@ -1511,6 +1567,10 @@ contrib_regression=# SELECT * FROM dblink_get_result('dtest1') AS t1(f1 int, f2 cancels any active query on the named connection + + dblink_cancel_query + + dblink_cancel_query(text connname) returns text @@ -1577,6 +1637,10 @@ SELECT dblink_cancel_query('dtest1'); + + dblink_get_pkey + + dblink_get_pkey(text relname) returns setof dblink_pkey_results @@ -1666,6 +1730,10 @@ SELECT * FROM dblink_get_pkey('foobar'); + + dblink_build_sql_insert + + dblink_build_sql_insert(text relname, @@ -1796,6 +1864,10 @@ SELECT dblink_build_sql_insert('foo', '1 2', 2, '{"1", "a"}', '{"1", "b''a"}'); + + dblink_build_sql_delete + + dblink_build_sql_delete(text relname, @@ -1910,6 +1982,10 @@ SELECT dblink_build_sql_delete('"MyFoo"', '1 2', 2, '{"1", "b"}'); + + dblink_build_sql_update + + dblink_build_sql_update(text relname, diff --git a/doc/src/sgml/earthdistance.sgml b/doc/src/sgml/earthdistance.sgml index 03dc38e280..ef869c5bc3 100644 --- a/doc/src/sgml/earthdistance.sgml +++ b/doc/src/sgml/earthdistance.sgml @@ -71,12 +71,12 @@ - earth() + earth()earth float8 Returns the assumed radius of the Earth. - sec_to_gc(float8) + sec_to_gc(float8)sec_to_gc float8 Converts the normal straight line (secant) distance between two points on the surface of the Earth @@ -84,7 +84,7 @@ - gc_to_sec(float8) + gc_to_sec(float8)gc_to_sec float8 Converts the great circle distance between two points on the surface of the Earth to the normal straight line (secant) distance @@ -92,35 +92,35 @@ - ll_to_earth(float8, float8) + ll_to_earth(float8, float8)ll_to_earth earth Returns the location of a point on the surface of the Earth given its latitude (argument 1) and longitude (argument 2) in degrees. - latitude(earth) + latitude(earth)latitude float8 Returns the latitude in degrees of a point on the surface of the Earth. - longitude(earth) + longitude(earth)longitude float8 Returns the longitude in degrees of a point on the surface of the Earth. - earth_distance(earth, earth) + earth_distance(earth, earth)earth_distance float8 Returns the great circle distance between two points on the surface of the Earth. - earth_box(earth, float8) + earth_box(earth, float8)earth_box cube Returns a box suitable for an indexed search using the cube @> diff --git a/doc/src/sgml/fuzzystrmatch.sgml b/doc/src/sgml/fuzzystrmatch.sgml index 5078bf82da..f26bd90dfc 100644 --- a/doc/src/sgml/fuzzystrmatch.sgml +++ b/doc/src/sgml/fuzzystrmatch.sgml @@ -35,6 +35,14 @@ for working with Soundex codes: + + soundex + + + + difference + + soundex(text) returns text difference(text, text) returns int @@ -81,6 +89,14 @@ SELECT * FROM s WHERE difference(s.nm, 'john') > 2; This function calculates the Levenshtein distance between two strings: + + levenshtein + + + + levenshtein_less_equal + + levenshtein(text source, text target, int ins_cost, int del_cost, int sub_cost) returns int levenshtein(text source, text target) returns int @@ -145,6 +161,10 @@ test=# SELECT levenshtein_less_equal('extensive', 'exhaustive',4); This function calculates the metaphone code of an input string: + + metaphone + + metaphone(text source, int max_output_length) returns text @@ -180,6 +200,14 @@ test=# SELECT metaphone('GUMBO', 4); These functions compute the primary and alternate codes: + + dmetaphone + + + + dmetaphone_alt + + dmetaphone(text source) returns text dmetaphone_alt(text source) returns text diff --git a/doc/src/sgml/hstore.sgml b/doc/src/sgml/hstore.sgml index 73c421d463..3810776e6d 100644 --- a/doc/src/sgml/hstore.sgml +++ b/doc/src/sgml/hstore.sgml @@ -233,7 +233,7 @@ key => NULL - hstore(record) + hstore(record)hstore hstore construct an hstore from a record or row hstore(ROW(1,2)) @@ -266,7 +266,7 @@ key => NULL - akeys(hstore) + akeys(hstore)akeys text[] get hstore's keys as an array akeys('a=>1,b=>2') @@ -274,7 +274,7 @@ key => NULL - skeys(hstore) + skeys(hstore)skeys setof text get hstore's keys as a set skeys('a=>1,b=>2') @@ -286,7 +286,7 @@ b - avals(hstore) + avals(hstore)avals text[] get hstore's values as an array avals('a=>1,b=>2') @@ -294,7 +294,7 @@ b - svals(hstore) + svals(hstore)svals setof text get hstore's values as a set svals('a=>1,b=>2') @@ -306,7 +306,7 @@ b - hstore_to_array(hstore) + hstore_to_array(hstore)hstore_to_array text[] get hstore's keys and values as an array of alternating keys and values @@ -315,7 +315,7 @@ b - hstore_to_matrix(hstore) + hstore_to_matrix(hstore)hstore_to_matrix text[] get hstore's keys and values as a two-dimensional array hstore_to_matrix('a=>1,b=>2') @@ -323,7 +323,7 @@ b - hstore_to_json(hstore) + hstore_to_json(hstore)hstore_to_json json get hstore as a json value hstore_to_json('"a key"=>1, b=>t, c=>null, d=>12345, e=>012345, f=>1.234, g=>2.345e+4') @@ -331,7 +331,7 @@ b - hstore_to_json_loose(hstore) + hstore_to_json_loose(hstore)hstore_to_json_loose json get hstore as a json value, but attempting to distinguish numerical and Boolean values so they are unquoted in the JSON hstore_to_json_loose('"a key"=>1, b=>t, c=>null, d=>12345, e=>012345, f=>1.234, g=>2.345e+4') @@ -339,7 +339,7 @@ b - slice(hstore, text[]) + slice(hstore, text[])slice hstore extract a subset of an hstore slice('a=>1,b=>2,c=>3'::hstore, ARRAY['b','c','x']) @@ -347,7 +347,7 @@ b - each(hstore) + each(hstore)each setof(key text, value text) get hstore's keys and values as a set select * from each('a=>1,b=>2') @@ -361,7 +361,7 @@ b - exist(hstore,text) + exist(hstore,text)exist boolean does hstore contain key? exist('a=>1','a') @@ -369,7 +369,7 @@ b - defined(hstore,text) + defined(hstore,text)defined boolean does hstore contain non-NULL value for key? defined('a=>NULL','a') @@ -377,7 +377,7 @@ b - delete(hstore,text) + delete(hstore,text)delete hstore delete pair with matching key delete('a=>1,b=>2','b') @@ -401,7 +401,7 @@ b - populate_record(record,hstore) + populate_record(record,hstore)populate_record record replace fields in record with matching values from hstore see Examples section diff --git a/doc/src/sgml/intagg.sgml b/doc/src/sgml/intagg.sgml index ea5acbe91f..669c901764 100644 --- a/doc/src/sgml/intagg.sgml +++ b/doc/src/sgml/intagg.sgml @@ -18,6 +18,14 @@ Functions + + int_array_aggregate + + + + array_agg + + The aggregator is an aggregate function int_array_aggregate(integer) @@ -27,6 +35,10 @@ which does the same thing for any array type. + + int_array_enum + + The enumerator is a function int_array_enum(integer[]) diff --git a/doc/src/sgml/intarray.sgml b/doc/src/sgml/intarray.sgml index 2bbd98ae37..a054d126f7 100644 --- a/doc/src/sgml/intarray.sgml +++ b/doc/src/sgml/intarray.sgml @@ -49,7 +49,7 @@ - icount(int[]) + icount(int[])icount int number of elements in array icount('{1,2,3}'::int[]) @@ -57,7 +57,7 @@ - sort(int[], text dir) + sort(int[], text dir)sort int[] sort array — dir must be asc or desc sort('{1,2,3}'::int[], 'desc') @@ -73,7 +73,7 @@ - sort_asc(int[]) + sort_asc(int[])sort_asc int[] sort in ascending order @@ -81,7 +81,7 @@ - sort_desc(int[]) + sort_desc(int[])sort_desc int[] sort in descending order @@ -89,7 +89,7 @@ - uniq(int[]) + uniq(int[])uniq int[] remove adjacent duplicates uniq(sort('{1,2,3,2,1}'::int[])) @@ -97,7 +97,7 @@ - idx(int[], int item) + idx(int[], int item)idx int index of first element matching item (0 if none) idx(array[11,22,33,22,11], 22) @@ -105,7 +105,7 @@ - subarray(int[], int start, int len) + subarray(int[], int start, int len)subarray int[] portion of array starting at position start, len elements subarray('{1,2,3,2,1}'::int[], 2, 3) @@ -121,7 +121,7 @@ - intset(int) + intset(int)intset int[] make single-element array intset(42) diff --git a/doc/src/sgml/isn.sgml b/doc/src/sgml/isn.sgml index f10285473d..4a2e7da763 100644 --- a/doc/src/sgml/isn.sgml +++ b/doc/src/sgml/isn.sgml @@ -240,7 +240,7 @@ - isn_weak(boolean) + isn_weak(boolean)isn_weak boolean Sets the weak input mode (returns new setting) @@ -250,12 +250,12 @@ Gets the current status of the weak mode - make_valid(isn) + make_valid(isn)make_valid isn Validates an invalid number (clears the invalid flag) - is_valid(isn) + is_valid(isn)is_valid boolean Checks for the presence of the invalid flag diff --git a/doc/src/sgml/ltree.sgml b/doc/src/sgml/ltree.sgml index f5a0ac98d4..cd8a061c94 100644 --- a/doc/src/sgml/ltree.sgml +++ b/doc/src/sgml/ltree.sgml @@ -381,7 +381,7 @@ Europe & Russia*@ & !Transportation - subltree(ltree, int start, int end) + subltree(ltree, int start, int end)subltree ltree subpath of ltree from position start to position end-1 (counting from 0) @@ -390,7 +390,7 @@ Europe & Russia*@ & !Transportation - subpath(ltree, int offset, int len) + subpath(ltree, int offset, int len)subpath ltree subpath of ltree starting at position offset, length len. @@ -413,7 +413,7 @@ Europe & Russia*@ & !Transportation - nlevel(ltree) + nlevel(ltree)nlevel integer number of labels in path nlevel('Top.Child1.Child2') @@ -421,7 +421,7 @@ Europe & Russia*@ & !Transportation - index(ltree a, ltree b) + index(ltree a, ltree b)index integer position of first occurrence of b in a; -1 if not found @@ -441,7 +441,7 @@ Europe & Russia*@ & !Transportation - text2ltree(text) + text2ltree(text)text2ltree ltree cast text to ltree @@ -449,7 +449,7 @@ Europe & Russia*@ & !Transportation - ltree2text(ltree) + ltree2text(ltree)ltree2text text cast ltree to text @@ -457,7 +457,7 @@ Europe & Russia*@ & !Transportation - lca(ltree, ltree, ...) + lca(ltree, ltree, ...)lca ltree lowest common ancestor, i.e., longest common prefix of paths (up to 8 arguments supported) diff --git a/doc/src/sgml/pageinspect.sgml b/doc/src/sgml/pageinspect.sgml index c4ff086c97..84477d24a7 100644 --- a/doc/src/sgml/pageinspect.sgml +++ b/doc/src/sgml/pageinspect.sgml @@ -18,6 +18,9 @@ + + get_raw_page + get_raw_page(relname text, fork text, blkno int) returns bytea @@ -49,6 +52,9 @@ + + page_header + page_header(page bytea) returns record @@ -76,6 +82,9 @@ test=# SELECT * FROM page_header(get_raw_page('pg_class', 0)); + + heap_page_items + heap_page_items(page bytea) returns setof record @@ -101,6 +110,9 @@ test=# SELECT * FROM heap_page_items(get_raw_page('pg_class', 0)); + + bt_metap + bt_metap(relname text) returns record @@ -124,6 +136,9 @@ fastlevel | 0 + + bt_page_stats + bt_page_stats(relname text, blkno int) returns record @@ -152,6 +167,9 @@ btpo_flags | 3 + + bt_page_items + bt_page_items(relname text, blkno int) returns setof record @@ -178,6 +196,9 @@ test=# SELECT * FROM bt_page_items('pg_cast_oid_index', 1); + + fsm_page_contents + fsm_page_contents(page bytea) returns text diff --git a/doc/src/sgml/pgbuffercache.sgml b/doc/src/sgml/pgbuffercache.sgml index 685351f11e..3c33a84994 100644 --- a/doc/src/sgml/pgbuffercache.sgml +++ b/doc/src/sgml/pgbuffercache.sgml @@ -12,6 +12,10 @@ examining what's happening in the shared buffer cache in real time. + + pg_buffercache_pages + + The module provides a C function pg_buffercache_pages that returns a set of records, plus a view diff --git a/doc/src/sgml/pgcrypto.sgml b/doc/src/sgml/pgcrypto.sgml index 6b78f2c1c6..a0eead7b84 100644 --- a/doc/src/sgml/pgcrypto.sgml +++ b/doc/src/sgml/pgcrypto.sgml @@ -23,6 +23,10 @@ <function>digest()</function> + + digest + + digest(data text, type text) returns bytea digest(data bytea, type text) returns bytea @@ -53,6 +57,10 @@ $$ LANGUAGE SQL STRICT IMMUTABLE; <function>hmac()</function> + + hmac + + hmac(data text, key text, type text) returns bytea hmac(data bytea, key text, type text) returns bytea @@ -173,6 +181,10 @@ hmac(data bytea, key text, type text) returns bytea <function>crypt()</> + + crypt + + crypt(password text, salt text) returns text @@ -202,6 +214,10 @@ SELECT pswhash = crypt('entered password', pswhash) FROM ... ; <function>gen_salt()</> + + gen_salt + + gen_salt(type text [, iter_count integer ]) returns text @@ -497,6 +513,14 @@ gen_salt(type text [, iter_count integer ]) returns text <function>pgp_sym_encrypt()</function> + + pgp_sym_encrypt + + + + pgp_sym_encrypt_bytea + + pgp_sym_encrypt(data text, psw text [, options text ]) returns bytea pgp_sym_encrypt_bytea(data bytea, psw text [, options text ]) returns bytea @@ -511,6 +535,14 @@ pgp_sym_encrypt_bytea(data bytea, psw text [, options text ]) returns bytea <function>pgp_sym_decrypt()</function> + + pgp_sym_decrypt + + + + pgp_sym_decrypt_bytea + + pgp_sym_decrypt(msg bytea, psw text [, options text ]) returns text pgp_sym_decrypt_bytea(msg bytea, psw text [, options text ]) returns bytea @@ -532,6 +564,14 @@ pgp_sym_decrypt_bytea(msg bytea, psw text [, options text ]) returns bytea <function>pgp_pub_encrypt()</function> + + pgp_pub_encrypt + + + + pgp_pub_encrypt_bytea + + pgp_pub_encrypt(data text, key bytea [, options text ]) returns bytea pgp_pub_encrypt_bytea(data bytea, key bytea [, options text ]) returns bytea @@ -549,6 +589,14 @@ pgp_pub_encrypt_bytea(data bytea, key bytea [, options text ]) returns bytea <function>pgp_pub_decrypt()</function> + + pgp_pub_decrypt + + + + pgp_pub_decrypt_bytea + + pgp_pub_decrypt(msg bytea, key bytea [, psw text [, options text ]]) returns text pgp_pub_decrypt_bytea(msg bytea, key bytea [, psw text [, options text ]]) returns bytea @@ -574,6 +622,10 @@ pgp_pub_decrypt_bytea(msg bytea, key bytea [, psw text [, options text ]]) retur <function>pgp_key_id()</function> + + pgp_key_id + + pgp_key_id(bytea) returns text @@ -616,6 +668,14 @@ pgp_key_id(bytea) returns text <function>armor()</function>, <function>dearmor()</function> + + armor + + + + dearmor + + armor(data bytea) returns text dearmor(data text) returns bytea @@ -913,6 +973,22 @@ gpg -a --export-secret-keys KEYID > secret.key encryption functions is discouraged. + + encrypt + + + + decrypt + + + + encrypt_iv + + + + decrypt_iv + + encrypt(data bytea, key bytea, type text) returns bytea decrypt(data bytea, key bytea, type text) returns bytea @@ -982,6 +1058,10 @@ encrypt(data, 'fooz', 'bf-cbc/pad:pkcs') Random-Data Functions + + gen_random_bytes + + gen_random_bytes(count integer) returns bytea diff --git a/doc/src/sgml/pgfreespacemap.sgml b/doc/src/sgml/pgfreespacemap.sgml index 4519a66a8d..7e070f1500 100644 --- a/doc/src/sgml/pgfreespacemap.sgml +++ b/doc/src/sgml/pgfreespacemap.sgml @@ -25,6 +25,9 @@ + + pg_freespace + pg_freespace(rel regclass IN, blkno bigint IN) returns int2 diff --git a/doc/src/sgml/pgrowlocks.sgml b/doc/src/sgml/pgrowlocks.sgml index c7714d8877..3e3e57f356 100644 --- a/doc/src/sgml/pgrowlocks.sgml +++ b/doc/src/sgml/pgrowlocks.sgml @@ -15,6 +15,10 @@ Overview + + pgrowlocks + + pgrowlocks(text) returns setof record diff --git a/doc/src/sgml/pgstatstatements.sgml b/doc/src/sgml/pgstatstatements.sgml index 5bd29a3f87..c02fdf4483 100644 --- a/doc/src/sgml/pgstatstatements.sgml +++ b/doc/src/sgml/pgstatstatements.sgml @@ -235,6 +235,10 @@ + + pg_stat_statements_reset + + pg_stat_statements_reset() returns void diff --git a/doc/src/sgml/pgstattuple.sgml b/doc/src/sgml/pgstattuple.sgml index 9f98448d7b..f2bc2a68f8 100644 --- a/doc/src/sgml/pgstattuple.sgml +++ b/doc/src/sgml/pgstattuple.sgml @@ -17,6 +17,10 @@ + + pgstattuple + + pgstattuple(text) returns record @@ -134,6 +138,9 @@ free_percent | 1.95 + + pgstatindex + pgstatindex(text) returns record @@ -246,6 +253,9 @@ leaf_fragmentation | 0 + + pgstatginindex + pgstatginindex(regclass) returns record @@ -303,6 +313,9 @@ pending_tuples | 0 + + pg_relpages + pg_relpages(text) returns bigint diff --git a/doc/src/sgml/pgtrgm.sgml b/doc/src/sgml/pgtrgm.sgml index 9039f03e8b..f66439523a 100644 --- a/doc/src/sgml/pgtrgm.sgml +++ b/doc/src/sgml/pgtrgm.sgml @@ -75,7 +75,7 @@ - similarity(text, text) + similarity(text, text)similarity real Returns a number that indicates how similar the two arguments are. @@ -85,7 +85,7 @@ - show_trgm(text) + show_trgm(text)show_trgm text[] Returns an array of all the trigrams in the given string. @@ -93,7 +93,7 @@ - show_limit() + show_limit()show_limit real Returns the current similarity threshold used by the % @@ -103,7 +103,7 @@ - set_limit(real) + set_limit(real)set_limit real Sets the current similarity threshold that is used by the % diff --git a/doc/src/sgml/sslinfo.sgml b/doc/src/sgml/sslinfo.sgml index 618182458a..783e03f0ad 100644 --- a/doc/src/sgml/sslinfo.sgml +++ b/doc/src/sgml/sslinfo.sgml @@ -24,9 +24,12 @@ - -ssl_is_used() returns boolean - + + ssl_is_used + + + ssl_is_used() returns boolean + Returns TRUE if current connection to server uses SSL, and FALSE @@ -36,9 +39,12 @@ ssl_is_used() returns boolean - -ssl_version() returns text - + + ssl_version + + + ssl_version() returns text + Returns the name of the protocol used for the SSL connection (e.g. SSLv2, @@ -48,9 +54,12 @@ ssl_version() returns text - -ssl_cipher() returns text - + + ssl_cipher + + + ssl_cipher() returns text + Returns the name of the cipher used for the SSL connection @@ -60,9 +69,12 @@ ssl_cipher() returns text - -ssl_client_cert_present() returns boolean - + + ssl_client_cert_present + + + ssl_client_cert_present() returns boolean + Returns TRUE if current client has presented a valid SSL client @@ -73,9 +85,12 @@ ssl_client_cert_present() returns boolean - -ssl_client_serial() returns numeric - + + ssl_client_serial + + + ssl_client_serial() returns numeric + Returns serial number of current client certificate. The combination of @@ -94,9 +109,12 @@ ssl_client_serial() returns numeric - -ssl_client_dn() returns text - + + ssl_client_dn + + + ssl_client_dn() returns text + Returns the full subject of the current client certificate, converting @@ -114,9 +132,12 @@ ssl_client_dn() returns text - -ssl_issuer_dn() returns text - + + ssl_issuer_dn + + + ssl_issuer_dn() returns text + Returns the full issuer name of the current client certificate, converting @@ -136,9 +157,12 @@ ssl_issuer_dn() returns text - -ssl_client_dn_field(fieldname text) returns text - + + ssl_client_dn_field + + + ssl_client_dn_field(fieldname text) returns text + This function returns the value of the specified field in the @@ -182,9 +206,12 @@ emailAddress - -ssl_issuer_field(fieldname text) returns text - + + ssl_issuer_field + + + ssl_issuer_field(fieldname text) returns text + Same as ssl_client_dn_field, but for the certificate issuer diff --git a/doc/src/sgml/tablefunc.sgml b/doc/src/sgml/tablefunc.sgml index cfa20e2a70..1d8423d5ae 100644 --- a/doc/src/sgml/tablefunc.sgml +++ b/doc/src/sgml/tablefunc.sgml @@ -86,6 +86,7 @@ [, text orderby_fld ], text start_with, int max_depth [, text branch_delim ]) + connectby setof record @@ -99,6 +100,10 @@ <function>normal_rand</function> + + normal_rand + + normal_rand(int numvals, float8 mean, float8 stddev) returns setof float8 @@ -142,6 +147,10 @@ test=# SELECT * FROM normal_rand(1000, 5, 3); <function>crosstab(text)</function> + + crosstab + + crosstab(text sql) crosstab(text sql, int N) @@ -289,6 +298,10 @@ AS ct(row_name text, category_1 text, category_2 text, category_3 text); <function>crosstab<replaceable>N</>(text)</function> + + crosstab + + crosstabN(text sql) @@ -396,6 +409,10 @@ CREATE OR REPLACE FUNCTION crosstab_float8_5_cols( <function>crosstab(text, text)</function> + + crosstab + + crosstab(text source_sql, text category_sql) @@ -602,6 +619,10 @@ AS <function>connectby</function> + + connectby + + connectby(text relname, text keyid_fld, text parent_keyid_fld [, text orderby_fld ], text start_with, int max_depth diff --git a/doc/src/sgml/uuid-ossp.sgml b/doc/src/sgml/uuid-ossp.sgml index 7446b8be5c..696cc112dc 100644 --- a/doc/src/sgml/uuid-ossp.sgml +++ b/doc/src/sgml/uuid-ossp.sgml @@ -42,7 +42,7 @@ - uuid_generate_v1() + uuid_generate_v1()uuid_generate_v1 This function generates a version 1 UUID. This involves the MAC @@ -54,7 +54,7 @@ - uuid_generate_v1mc() + uuid_generate_v1mc()uuid_generate_v1mc This function generates a version 1 UUID but uses a random multicast @@ -63,7 +63,7 @@ - uuid_generate_v3(namespace uuid, name text) + uuid_generate_v3(namespace uuid, name text)uuid_generate_v3 This function generates a version 3 UUID in the given namespace using diff --git a/doc/src/sgml/xml2.sgml b/doc/src/sgml/xml2.sgml index adc923bacc..df0f53c549 100644 --- a/doc/src/sgml/xml2.sgml +++ b/doc/src/sgml/xml2.sgml @@ -197,6 +197,10 @@ <literal>xpath_table</literal> + + xpath_table + + xpath_table(text key, text document, text relation, text xpaths, text criteria) returns setof record @@ -423,6 +427,10 @@ ORDER BY doc_num, line_num; <literal>xslt_process</literal> + + xslt_process + + xslt_process(text document, text stylesheet, text paramlist) returns text -- 2.40.0