diff options
| author | Thomas G. Lockhart <lockhart@fourpalms.org> | 1998-07-29 06:32:47 +0000 |
|---|---|---|
| committer | Thomas G. Lockhart <lockhart@fourpalms.org> | 1998-07-29 06:32:47 +0000 |
| commit | bd6b6f40de75401d282121fa5f084c98dd65708a (patch) | |
| tree | 405b332af5e4c5515bdcfc2abb310b4e4951d301 /doc/src | |
| parent | 32de56e8174e0537f782a88e9df766d76ea4cbbb (diff) | |
| download | postgresql-bd6b6f40de75401d282121fa5f084c98dd65708a.tar.gz postgresql-bd6b6f40de75401d282121fa5f084c98dd65708a.zip | |
Add missing information.
Fix examples for regex operators.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 16 | ||||
| -rw-r--r-- | doc/src/sgml/oper.sgml | 10 |
2 files changed, 19 insertions, 7 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 91d86a9fa77..e2e4d9deeaa 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -1,4 +1,4 @@ -<Chapter> +<Chapter Id="functions"> <Title>Functions</Title> <Abstract> @@ -74,7 +74,7 @@ are implemented using other <ProductName>Postgres</ProductName> functions. <Para> <TABLE TOCENTRY="1"> -<TITLE><Acronym>SQL92</Acronym> Text Functions</TITLE> +<TITLE><Acronym>SQL92</Acronym> String Functions</TITLE> <TGROUP COLS="4"> <THEAD> <ROW> @@ -139,6 +139,12 @@ Some are used internally to implement the SQL92 string functions listed above. <ENTRY> char(varchar 'varchar string') </ENTRY> </ROW> <ROW> +<ENTRY> initcap(text) </ENTRY> +<ENTRY> text </ENTRY> +<ENTRY> first letter of each word to upper case </ENTRY> +<ENTRY> initcap('thomas') </ENTRY> + </ROW> + <ROW> <ENTRY> lower(text) </ENTRY> <ENTRY> text </ENTRY> <ENTRY> convert text to lower case </ENTRY> @@ -193,6 +199,12 @@ Some are used internally to implement the SQL92 string functions listed above. <ENTRY> text(varchar 'varchar string') </ENTRY> </ROW> <ROW> +<ENTRY> translate(text,from,to) </ENTRY> +<ENTRY> text </ENTRY> +<ENTRY> convert character in string </ENTRY> +<ENTRY> translate('12345', '1', 'a') </ENTRY> + </ROW> + <ROW> <ENTRY> varchar(char) </ENTRY> <ENTRY> varchar </ENTRY> <ENTRY> convert char to varchar type </ENTRY> diff --git a/doc/src/sgml/oper.sgml b/doc/src/sgml/oper.sgml index 5ec76cf452e..663d65e6b02 100644 --- a/doc/src/sgml/oper.sgml +++ b/doc/src/sgml/oper.sgml @@ -1,4 +1,4 @@ -<Chapter> +<Chapter Id="operators"> <Title>Operators</Title> <Abstract> @@ -102,22 +102,22 @@ from numeric types to data/time types. <ROW> <ENTRY> ~ </ENTRY> <ENTRY>Match (regex), case sensitive</ENTRY> - <ENTRY>'thomas' ~ '*.thomas*.'</ENTRY> + <ENTRY>'thomas' ~ '.*thomas.*'</ENTRY> </ROW> <ROW> <ENTRY> ~* </ENTRY> <ENTRY>Match (regex), case insensitive</ENTRY> - <ENTRY>'thomas' ~* '*.Thomas*.'</ENTRY> + <ENTRY>'thomas' ~* '.*Thomas.*'</ENTRY> </ROW> <ROW> <ENTRY> !~ </ENTRY> <ENTRY>Does not match (regex), case sensitive</ENTRY> - <ENTRY>'thomas' !~ '*.Thomas*.'</ENTRY> + <ENTRY>'thomas' !~ '.*Thomas.*'</ENTRY> </ROW> <ROW> <ENTRY> !~* </ENTRY> <ENTRY>Does not match (regex), case insensitive</ENTRY> - <ENTRY>'thomas' !~ '*.vadim*.'</ENTRY> + <ENTRY>'thomas' !~ '.*vadim.*'</ENTRY> </ROW> </TBODY> </TGROUP> |