diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 7a270eb..fef21bb 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -1798,243 +1798,282 @@ Other String Functions - + + + + + - Function - Return Type - Description - Example - Result + Function + SignatureDescriptionExample(s) - + ascii - ascii(string) + ascii ( text ) + integer - 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('x') + 120 - ascii('x') - 120 - + btrim - btrim(string text - , characters text) + btrim ( string text + , characters text ) + text - 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('xyxtrimyyx', 'xyz') + trim - btrim('xyxtrimyyx', 'xyz') - trim - + chr - chr(int) + chr ( integer ) + text - 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(65) + A - chr(65) - A - + concat - concat(str "any" - [, str "any" [, ...] ]) + concat ( val "any" + [, val "any" [, ...] ] ) + text - text - - Concatenate the text representations of all the arguments. + + + + Concatenates the text representations of all the arguments. NULL arguments are ignored. + + concat('abcde', 2, NULL, 22) + abcde222 - concat('abcde', 2, NULL, 22) - abcde222 - + concat_ws - concat_ws(sep text, - str "any" - [, str "any" [, ...] ]) + concat_ws ( sep text, + val "any" + [, val "any" [, ...] ] ) + text - 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(',', 'abcde', 2, NULL, 22) + abcde,2,22 - concat_ws(',', 'abcde', 2, NULL, 22) - abcde,2,22 - + format - format(formatstr text - [, formatarg "any" [, ...] ]) + format ( formatstr text + [, formatarg "any" [, ...] ] ) + text - 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('Hello %s, %1$s', 'World') + Hello World, World - format('Hello %s, %1$s', 'World') - Hello World, World - + initcap - initcap(string) + initcap ( text ) + text - 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('hi THOMAS') + Hi Thomas - initcap('hi THOMAS') - Hi Thomas - + left - left(string text, - n int) + left ( string text, + n integer ) + text + + + + + Returns first n characters in the + string, or when n is negative, returns + all but last |n| characters. + + left('abcde', 2) + ab - text - - Return first n characters in the - string, or when n is negative, return - all but last |n| characters - - left('abcde', 2) - ab - + length - length(string) + length ( text ) + integer - int - - Number of characters in string + + + + Returns the number of characters in the string. + + length('jose') + 4 - length('jose') - 4 - + lpad - lpad(string text, - length int - , fill text) + lpad ( string text, + length integer + , fill text ) + text - 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('hi', 5, 'xy') + xyxhi - lpad('hi', 5, 'xy') - xyxhi - + ltrim - ltrim(string text - , characters text) + ltrim ( string text + , characters text ) + text - 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('zzzytest', 'xyz') + test - ltrim('zzzytest', 'xyz') - test - + md5 - md5(string) + md5 ( text ) + text - text - - MD5 hash, with - the result written in hexadecimal + + + + Computes MD5 hash, with + the result written in hexadecimal. + + md5('abc') + 900150983cd24fb0&zwsp;d6963f7d28e17f72 - md5('abc') - 900150983cd24fb0 d6963f7d28e17f72 - + parse_ident - parse_ident(qualified_identifier text - [, strictmode boolean DEFAULT true ] ) + parse_ident ( qualified_identifier text + [, strictmode boolean DEFAULT true ] ) + text[] - 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 +2081,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('"SomeSchema".someTable') + {SomeSchema,sometable} - parse_ident('"SomeSchema".someTable') - {SomeSchema,sometable} - + pg_client_encoding - pg_client_encoding() + pg_client_encoding ( ) + name - name - - Current client encoding name + + + + Returns current client encoding name. + + pg_client_encoding() + SQL_ASCII - pg_client_encoding() - SQL_ASCII - + quote_ident - quote_ident(string text) + quote_ident ( text ) + text - 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('Foo bar') + "Foo bar" - quote_ident('Foo bar') - "Foo bar" - + quote_literal - quote_literal(string text) + quote_literal ( text ) + text - 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(E'O\'Reilly') + 'O''Reilly' - quote_literal(E'O\'Reilly') - 'O''Reilly' - quote_literal(value anyelement) - text - - Coerce the given value to text and then quote it as a literal. + + quote_literal ( anyelement ) + text + + + + + Coerces the given value to text and then quotes it as a literal. Embedded single-quotes and backslashes are properly doubled. + + quote_literal(42.5) + '42.5' - quote_literal(42.5) - '42.5' - + quote_nullable - quote_nullable(string text) + quote_nullable ( text ) + text - 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(NULL) + NULL - quote_nullable(NULL) - NULL - quote_nullable(value anyelement) - text - - Coerce the given value to text and then quote it as a literal; - or, if the argument is null, return NULL. + + quote_nullable ( anyelement ) + text + + + + + 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(42.5) + '42.5' - quote_nullable(42.5) - '42.5' - + regexp_match - regexp_match(string text, pattern text [, flags text]) + regexp_match ( string text, pattern text [, flags text ] ) + text[] - 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('foobarbequebaz', '(bar)(beque)') + {bar,beque} - regexp_match('foobarbequebaz', '(bar)(beque)') - {bar,beque} - + regexp_matches - regexp_matches(string text, pattern text [, flags text]) + regexp_matches ( string text, pattern text [, flags text ] ) + setof text[] - 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('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 ( string text, pattern text, replacement text [, flags text ] ) + text - text - - Replace substring(s) matching a POSIX regular expression (see - for more information) + + + + Replaces substring(s) matching a POSIX regular expression; see + . + + 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 ( string text, pattern text [, flags text ] ) + text[] - 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('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 ( string text, pattern text [, flags text ] ) + setof text - 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('hello world', '\s+') + helloworld(2 rows) - regexp_split_to_table('hello world', '\s+') - helloworld (2 rows) - + repeat - repeat(string text, number int) + repeat ( string text, number integer ) + text + + + + + Repeats string the specified + number of times. + + repeat('Pg', 4) + PgPgPgPg - text - Repeat string the specified - number of times - repeat('Pg', 4) - PgPgPgPg - + replace - replace(string text, + replace ( string text, from text, - to text) + to text ) + text - text - Replace all occurrences in string of substring - from with substring to + + + + Replaces all occurrences in string of + substring from with + substring to. + + replace('abcdefabcdef', 'cd', 'XX') + abXXefabXXef - replace('abcdefabcdef', 'cd', 'XX') - abXXefabXXef - + reverse - reverse(str) + reverse ( text ) + text - text - - Reverse the order of the characters in string + + + + Reverses the order of the characters in the string. + + reverse('abcde') + edcba - reverse('abcde') - edcba - + right - right(string text, - n int) + right ( string text, + n integer ) + ) + text - 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('abcde', 2) + de - right('abcde', 2) - de - + rpad - rpad(string text, - length int - , fill text) + rpad ( string text, + length integer + , fill text ) + ) + text - 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('hi', 5, 'xy') + hixyx - rpad('hi', 5, 'xy') - hixyx - + rtrim - rtrim(string text - , characters text) + rtrim ( string text + , characters text ) + text - 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('testxxzx', 'xyz') + test - rtrim('testxxzx', 'xyz') - test - + split_part - split_part(string text, + split_part ( string text, delimiter text, - field int) + n integer ) + text - 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('abc~@~def~@~ghi', '~@~', 2) + def - split_part('abc~@~def~@~ghi', '~@~', 2) - def - + strpos - strpos(string, substring) + strpos ( string text, substring text ) + integer - 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('high', 'ig') + 2 - strpos('high', 'ig') - 2 - + substr - substr(string, from , count) + substr ( string text, start integer , count integer ) + ) + text - 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('alphabet', 3, 2) + ph - substr('alphabet', 3, 2) - ph - + starts_with - starts_with(string, prefix) + starts_with ( string text, prefix text ) + boolean - bool - - Return true if string starts - with prefix + + + + Returns true if string starts + with prefix. + + starts_with('alphabet', 'alph') + t - starts_with('alphabet', 'alph') - t - + to_ascii - to_ascii(string text - , encoding text) + to_ascii ( string text + , encoding name or integer ) + text - 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('Karél') + Karel - to_ascii('Karel') - Karel - + to_hex - to_hex(number int - or bigint) + to_hex ( number + integer + or bigint ) + text - text - Convert number to its equivalent hexadecimal - representation + + + + Converts number to its equivalent hexadecimal + representation. + + to_hex(2147483647) + 7fffffff - to_hex(2147483647) - 7fffffff - + translate - translate(string text, + translate ( string text, from text, - to text) + to text ) + text - 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('12345', '143', 'ax') + a2x5 - translate('12345', '143', 'ax') - a2x5 @@ -8645,80 +8780,74 @@ CREATE TYPE rainbow AS ENUM ('red', 'orange', 'yellow', 'green', 'blue', 'purple
Enum Support Functions - - - - - - - - - + + + + + - Function - Signature - - - Description - - - Example - Example Result + Function + SignatureDescriptionExample(s) - + enum_first - enum_first + enum_first ( anyenum ) + anyenum - 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(null::rainbow) + red + - + enum_last - enum_last + enum_last ( anyenum ) + anyenum - 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(null::rainbow) + purple + - + enum_range - enum_range + enum_range ( anyenum ) + anyarray - 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} + + Returns all values of the input enum type in an ordered array. + + enum_range(null::rainbow) + {red,orange,yellow,&zwsp;green,blue,purple} + - enum_range - enum_range(anyenum, anyenum) anyarray + + enum_range ( anyenum, anyenum ) + anyarray + @@ -8728,20 +8857,17 @@ CREATE TYPE rainbow AS ENUM ('red', 'orange', 'yellow', 'green', 'blue', 'purple the enum type. If the second parameter is null, the result will end with the last value of the enum type. + + enum_range('orange'::rainbow, 'green'::rainbow) + {orange,yellow,green} + + enum_range(NULL, 'green'::rainbow) + {red,orange,&zwsp;yellow,green} + + enum_range('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 @@ + + + + +