diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 7a270eb..84a7e57 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -1798,243 +1798,276 @@ Other String Functions - + + + Function - Return Type - Description - Example - Result + DescriptionSignatureExample(s) - + ascii - ascii(string) + ascii - int - ASCII code of the first character of the - argument. For UTF8 returns the Unicode code - point of the character. For other multibyte encodings, the - argument must be an ASCII character. + Returns the numeric code of the first character of the argument. + In UTF8 encoding, returns the Unicode code point + of the character. In other multibyte encodings, the argument must + be an ASCII character. + + ascii ( text ) + integer + + ascii('x') + 120 - ascii('x') - 120 - + btrim - btrim(string text - , characters text) + btrim - text - Remove the longest string consisting only of characters + Removes the longest string consisting only of characters in characters (a space by default) - from the start and end of string + from the start and end of string. + + btrim ( string text + , characters text ) + text + + btrim('xyxtrimyyx', 'xyz') + trim - btrim('xyxtrimyyx', 'xyz') - trim - + chr - chr(int) + chr - text - Character with the given code. For UTF8 the - argument is treated as a Unicode code point. For other multibyte - encodings the argument must designate an - ASCII character. The NULL (0) character is not - allowed because text data types cannot store such bytes. + Returns the character with the given + code. In UTF8 encoding the argument is treated as + a Unicode code point. In other multibyte encodings the argument must + designate an ASCII character. The NULL (0) + character is not allowed because text data types cannot store such + bytes. + + chr ( integer ) + text + + chr(65) + A - chr(65) - A - + concat - concat(str "any" - [, str "any" [, ...] ]) + concat - text - Concatenate the text representations of all the arguments. + Concatenates the text representations of all the arguments. NULL arguments are ignored. + + concat ( val "any" + [, val "any" [, ...] ] ) + text + + concat('abcde', 2, NULL, 22) + abcde222 - concat('abcde', 2, NULL, 22) - abcde222 - + concat_ws - concat_ws(sep text, - str "any" - [, str "any" [, ...] ]) + concat_ws - text - Concatenate all but the first argument with separators. The first + Concatenates all but the first argument, with separators. The first argument is used as the separator string. NULL arguments are ignored. + + concat_ws ( sep text, + val "any" + [, val "any" [, ...] ] ) + text + + concat_ws(',', 'abcde', 2, NULL, 22) + abcde,2,22 - concat_ws(',', 'abcde', 2, NULL, 22) - abcde,2,22 - + format - format(formatstr text - [, formatarg "any" [, ...] ]) + format - text - Format arguments according to a format string. + Formats arguments according to a format string; + see . This function is similar to the C function sprintf. - See . + + format ( formatstr text + [, formatarg "any" [, ...] ] ) + text + + format('Hello %s, %1$s', 'World') + Hello World, World - format('Hello %s, %1$s', 'World') - Hello World, World - + initcap - initcap(string) + initcap - text - Convert the first letter of each word to upper case and the + Converts the first letter of each word to upper case and the rest to lower case. Words are sequences of alphanumeric characters separated by non-alphanumeric characters. + + initcap ( text ) + text + + initcap('hi THOMAS') + Hi Thomas - initcap('hi THOMAS') - Hi Thomas - + left - left(string text, - n int) + left - text - Return first n characters in the - string, or when n is negative, return - all but last |n| characters - - left('abcde', 2) - ab + Returns first n characters in the + string, or when n is negative, returns + all but last |n| characters. + + left ( string text, + n integer ) + text + + left('abcde', 2) + ab + - + length - length(string) + length - int - Number of characters in string + Returns the number of characters in the string. + + length ( text ) + integer + + length('jose') + 4 - length('jose') - 4 - + lpad - lpad(string text, - length int - , fill text) + lpad - text - Extend the string to length + Extends the string to length length by prepending the characters fill (a space by default). If the string is already longer than - length then it is truncated (on the - right). + length then it is truncated (on the right). + + lpad ( string text, + length integer + , fill text ) + text + + lpad('hi', 5, 'xy') + xyxhi - lpad('hi', 5, 'xy') - xyxhi - + ltrim - ltrim(string text - , characters text) + ltrim - text - Remove the longest string containing only characters from + Removes the longest string containing only characters from characters (a space by default) from the start of - string + string. + + ltrim ( string text + , characters text ) + text + + ltrim('zzzytest', 'xyz') + test - ltrim('zzzytest', 'xyz') - test - + md5 - md5(string) + md5 - text - MD5 hash, with - the result written in hexadecimal + Computes MD5 hash, with + the result written in hexadecimal. + + md5 ( text ) + text + + md5('abc') + 900150983cd24fb0&zwsp;d6963f7d28e17f72 - md5('abc') - 900150983cd24fb0 d6963f7d28e17f72 - + parse_ident - parse_ident(qualified_identifier text - [, strictmode boolean DEFAULT true ] ) + parse_ident - text[] - Split qualified_identifier into an array of + Splits qualified_identifier into an array of identifiers, removing any quoting of individual identifiers. By default, extra characters after the last identifier are considered an error; but if the second parameter is false, then such @@ -2042,417 +2075,513 @@ names for objects like functions.) Note that this function does not truncate over-length identifiers. If you want truncation you can cast the result to name[]. + + parse_ident ( qualified_identifier text + [, strictmode boolean DEFAULT true ] ) + text[] + + parse_ident('"SomeSchema".someTable') + {SomeSchema,sometable} - parse_ident('"SomeSchema".someTable') - {SomeSchema,sometable} - + pg_client_encoding - pg_client_encoding() + pg_client_encoding - name - Current client encoding name + Returns current client encoding name. + + pg_client_encoding ( ) + name + + pg_client_encoding() + SQL_ASCII - pg_client_encoding() - SQL_ASCII - + quote_ident - quote_ident(string text) + quote_ident - text - Return the given string suitably quoted to be used as an identifier + Returns the given string suitably quoted to be used as an identifier in an SQL statement string. Quotes are added only if necessary (i.e., if the string contains non-identifier characters or would be case-folded). Embedded quotes are properly doubled. See also . + + quote_ident ( text ) + text + + quote_ident('Foo bar') + "Foo bar" - quote_ident('Foo bar') - "Foo bar" - + quote_literal - quote_literal(string text) + quote_literal - text - Return the given string suitably quoted to be used as a string literal + Returns the given string suitably quoted to be used as a string literal in an SQL statement string. Embedded single-quotes and backslashes are properly doubled. Note that quote_literal returns null on null input; if the argument might be null, quote_nullable is often more suitable. See also . + + quote_literal ( text ) + text + + quote_literal(E'O\'Reilly') + 'O''Reilly' - quote_literal(E'O\'Reilly') - 'O''Reilly' - quote_literal(value anyelement) - text + quote_literal - Coerce the given value to text and then quote it as a literal. + Coerces the given value to text and then quotes it as a literal. Embedded single-quotes and backslashes are properly doubled. + + quote_literal ( anyelement ) + text + + quote_literal(42.5) + '42.5' - quote_literal(42.5) - '42.5' - + quote_nullable - quote_nullable(string text) + quote_nullable - text - Return the given string suitably quoted to be used as a string literal + Returns the given string suitably quoted to be used as a string literal in an SQL statement string; or, if the argument - is null, return NULL. + is null, returns NULL. Embedded single-quotes and backslashes are properly doubled. See also . + + quote_nullable ( text ) + text + + quote_nullable(NULL) + NULL - quote_nullable(NULL) - NULL - quote_nullable(value anyelement) - text + quote_nullable - Coerce the given value to text and then quote it as a literal; - or, if the argument is null, return NULL. + Coerces the given value to text and then quotes it as a literal; + or, if the argument is null, returns NULL. Embedded single-quotes and backslashes are properly doubled. + + quote_nullable ( anyelement ) + text + + quote_nullable(42.5) + '42.5' - quote_nullable(42.5) - '42.5' - + regexp_match - regexp_match(string text, pattern text [, flags text]) + regexp_match - text[] - Return captured substring(s) resulting from the first match of a POSIX - regular expression to the string (see - for more information) + Returns captured substring(s) resulting from the first match of a POSIX + regular expression to the string; see + . + + regexp_match ( string text, pattern text [, flags text ] ) + text[] + + regexp_match('foobarbequebaz', '(bar)(beque)') + {bar,beque} - regexp_match('foobarbequebaz', '(bar)(beque)') - {bar,beque} - + regexp_matches - regexp_matches(string text, pattern text [, flags text]) + regexp_matches - setof text[] - Return captured substring(s) resulting from matching a POSIX regular - expression to the string (see - for more information) + Returns captured substring(s) resulting from matching a POSIX regular + expression to the string; see + . + + regexp_matches ( string text, pattern text [, flags text ] ) + setof text[] + + regexp_matches('foobarbequebaz', 'ba.', 'g') + {bar}{baz}(2 rows) - regexp_matches('foobarbequebaz', 'ba.', 'g') - {bar}{baz} (2 rows) - + regexp_replace - regexp_replace(string text, pattern text, replacement text [, flags text]) + regexp_replace - text - Replace substring(s) matching a POSIX regular expression (see - for more information) + Replaces substring(s) matching a POSIX regular expression; see + . + + regexp_replace ( string text, pattern text, replacement text [, flags text ] ) + text + + regexp_replace('Thomas', '.[mN]a.', 'M') + ThM - regexp_replace('Thomas', '.[mN]a.', 'M') - ThM - + regexp_split_to_array - regexp_split_to_array(string text, pattern text [, flags text ]) + regexp_split_to_array - text[] - Split string using a POSIX regular expression as - the delimiter (see for more - information) + Splits string using a POSIX regular + expression as the delimiter; see + . + + regexp_split_to_array ( string text, pattern text [, flags text ] ) + text[] + + regexp_split_to_array('hello world', '\s+') + {hello,world} - regexp_split_to_array('hello world', '\s+') - {hello,world} - + regexp_split_to_table - regexp_split_to_table(string text, pattern text [, flags text]) + regexp_split_to_table - setof text - Split string using a POSIX regular expression as - the delimiter (see for more - information) + Splits string using a POSIX regular + expression as the delimiter; see + . + + regexp_split_to_table ( string text, pattern text [, flags text ] ) + setof text + + regexp_split_to_table('hello world', '\s+') + helloworld(2 rows) - regexp_split_to_table('hello world', '\s+') - helloworld (2 rows) - + repeat - repeat(string text, number int) + repeat + + + Repeats string the specified + number of times. + + repeat ( string text, number integer ) + text + + repeat('Pg', 4) + PgPgPgPg - text - Repeat string the specified - number of times - repeat('Pg', 4) - PgPgPgPg - + replace - replace(string text, - from text, - to text) + replace - text - Replace all occurrences in string of substring - from with substring to + + Replaces all occurrences in string of + substring from with + substring to. + + replace ( string text, + from text, + to text ) + text + + replace('abcdefabcdef', 'cd', 'XX') + abXXefabXXef - replace('abcdefabcdef', 'cd', 'XX') - abXXefabXXef - + reverse - reverse(str) + reverse - text - Reverse the order of the characters in string + Reverses the order of the characters in the string. + + reverse ( text ) + text + + reverse('abcde') + edcba - reverse('abcde') - edcba - + right - right(string text, - n int) + right - text - Return last n characters in the string, - or when n is negative, return all but - first |n| characters + Returns last n characters in the string, + or when n is negative, returns all but + first |n| characters. + + right ( string text, + n integer ) + ) + text + + right('abcde', 2) + de - right('abcde', 2) - de - + rpad - rpad(string text, - length int - , fill text) + rpad - text - Extend the string to length + Extends the string to length length by appending the characters fill (a space by default). If the string is already longer than length then it is truncated. + + rpad ( string text, + length integer + , fill text ) + ) + text + + rpad('hi', 5, 'xy') + hixyx - rpad('hi', 5, 'xy') - hixyx - + rtrim - rtrim(string text - , characters text) + rtrim - text - Remove the longest string containing only characters from + Removes the longest string containing only characters from characters (a space by default) from the end of - string + string. + + rtrim ( string text + , characters text ) + text + + rtrim('testxxzx', 'xyz') + test - rtrim('testxxzx', 'xyz') - test - + split_part - split_part(string text, - delimiter text, - field int) + split_part - text - Split string on delimiter - and return the given field (counting from one) + + Splits string on delimiter + and returns the n'th field (counting from one). + + split_part ( string text, + delimiter text, + n integer ) + text + + split_part('abc~@~def~@~ghi', '~@~', 2) + def - split_part('abc~@~def~@~ghi', '~@~', 2) - def - + strpos - strpos(string, substring) + strpos - int - Location of specified substring (same as - position(substring in - string), but note the reversed - argument order) + Returns location of specified substring + within string, or zero if it's not present. + (Same as position(substring in + string), but note the reversed + argument order.) + + strpos ( string text, substring text ) + integer + + strpos('high', 'ig') + 2 - strpos('high', 'ig') - 2 - + substr - substr(string, from , count) + substr - text - Extract substring (same as - substring(string from from for count)) + Extracts substring starting at index start, + and extending for count characters if that is + specified. (Same + as substring(string + from start + for count).) + + substr ( string text, start integer , count integer ) + ) + text + + substr('alphabet', 3, 2) + ph - substr('alphabet', 3, 2) - ph - + starts_with - starts_with(string, prefix) + starts_with - bool - Return true if string starts - with prefix + Returns true if string starts + with prefix. + + starts_with ( string text, prefix text ) + boolean + + starts_with('alphabet', 'alph') + t - starts_with('alphabet', 'alph') - t - + to_ascii - to_ascii(string text - , encoding text) + to_ascii - text - Convert string to ASCII from another encoding - (only supports conversion from LATIN1, LATIN2, LATIN9, - and WIN1250 encodings) + Converts string to ASCII + from another encoding, which may be identified by name or number; + if encoding is omitted the database encoding + is assumed. The conversion consists primarily of dropping accents. + Conversion is only supported + from LATIN1, LATIN2, + LATIN9, and WIN1250 encodings. + + to_ascii ( string text + , encoding name or integer ) + text + + to_ascii('Karél') + Karel - to_ascii('Karel') - Karel - + to_hex - to_hex(number int - or bigint) + to_hex - text - Convert number to its equivalent hexadecimal - representation + + Converts number to its equivalent hexadecimal + representation. + + to_hex ( number + integer + or bigint ) + text + + to_hex(2147483647) + 7fffffff - to_hex(2147483647) - 7fffffff - + translate - translate(string text, - from text, - to text) + translate - text - Any character in string that matches a - character in the from set is replaced by - the corresponding character in the to + Replaces each character in string that + matches a character in the from set with the + corresponding character in the to set. If from is longer than to, occurrences of the extra characters in - from are removed. + from are deleted. + + translate ( string text, + from text, + to text ) + text + + translate('12345', '143', 'ax') + a2x5 - translate('12345', '143', 'ax') - a2x5 @@ -8645,103 +8774,90 @@ CREATE TYPE rainbow AS ENUM ('red', 'orange', 'yellow', 'green', 'blue', 'purple
Enum Support Functions - - - - - - - - - + + + - Function - Signature - - - Description - - - Example - Example Result + Function + DescriptionSignatureExample(s) - + enum_first enum_first - enum_first(anyenum) anyenum - - - Returns the first value of the input enum type - - - enum_first(&zwsp;null::rainbow) - red + + Returns the first value of the input enum type. + + enum_first ( anyenum ) + anyenum + + enum_first(&zwsp;null::rainbow) + red + - + enum_last enum_last - enum_last(anyenum) anyenum - - - Returns the last value of the input enum type - - - enum_last(&zwsp;null::rainbow) - purple + + Returns the last value of the input enum type. + + enum_last ( anyenum ) + anyenum + + enum_last(&zwsp;null::rainbow) + purple + - + enum_range enum_range - enum_range(anyenum) anyarray - - - Returns all values of the input enum type in an ordered array - - - enum_range(&zwsp;null::rainbow) - {red,orange,yellow,&zwsp;green,blue,purple} - - - enum_range - enum_range(anyenum, anyenum) anyarray + + Returns all values of the input enum type in an ordered array. + + enum_range ( anyenum ) + anyarray + + enum_range(&zwsp;null::rainbow) + {red,orange,yellow,&zwsp;green,blue,purple} + - + enum_range + Returns the range between the two given enum values, as an ordered array. The values must be from the same enum type. If the first parameter is null, the result will start with the first value of the enum type. If the second parameter is null, the result will end with the last value of the enum type. + + enum_range ( anyenum, anyenum ) + anyarray + + enum_range(&zwsp;'orange'::rainbow, 'green'::rainbow) + {orange,yellow,green} + + enum_range(NULL, 'green'::rainbow) + {red,orange,&zwsp;yellow,green} + + enum_range(&zwsp;'orange'::rainbow, NULL) + {orange,yellow,green,&zwsp;blue,purple} - - enum_range(&zwsp;'orange'::rainbow, 'green'::rainbow) - {orange,yellow,green} - - - enum_range(NULL, 'green'::rainbow) - {red,orange,yellow,&zwsp;green} - - - enum_range(&zwsp;'orange'::rainbow, NULL) - {orange,yellow,green,&zwsp;blue,purple} -
diff --git a/doc/src/sgml/stylesheet-common.xsl b/doc/src/sgml/stylesheet-common.xsl index a13565e..105ed1c 100644 --- a/doc/src/sgml/stylesheet-common.xsl +++ b/doc/src/sgml/stylesheet-common.xsl @@ -103,4 +103,11 @@ + + + + +
+ + diff --git a/doc/src/sgml/stylesheet-fo.xsl b/doc/src/sgml/stylesheet-fo.xsl index 2aaae82..713159d 100644 --- a/doc/src/sgml/stylesheet-fo.xsl +++ b/doc/src/sgml/stylesheet-fo.xsl @@ -70,6 +70,11 @@ + + + + +