Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitbd6b6f4

Browse files
author
Thomas G. Lockhart
committed
Add missing information.
Fix examples for regex operators.
1 parent32de56e commitbd6b6f4

File tree

2 files changed

+19
-7
lines changed

2 files changed

+19
-7
lines changed

‎doc/src/sgml/func.sgml

Lines changed: 14 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
<Chapter>
1+
<Chapter Id="functions">
22
<Title>Functions</Title>
33

44
<Abstract>
@@ -74,7 +74,7 @@ are implemented using other <ProductName>Postgres</ProductName> functions.
7474

7575
<Para>
7676
<TABLE TOCENTRY="1">
77-
<TITLE><Acronym>SQL92</Acronym>Text Functions</TITLE>
77+
<TITLE><Acronym>SQL92</Acronym>String Functions</TITLE>
7878
<TGROUP COLS="4">
7979
<THEAD>
8080
<ROW>
@@ -139,6 +139,12 @@ Some are used internally to implement the SQL92 string functions listed above.
139139
<ENTRY> char(varchar 'varchar string') </ENTRY>
140140
</ROW>
141141
<ROW>
142+
<ENTRY> initcap(text) </ENTRY>
143+
<ENTRY> text </ENTRY>
144+
<ENTRY> first letter of each word to upper case </ENTRY>
145+
<ENTRY> initcap('thomas') </ENTRY>
146+
</ROW>
147+
<ROW>
142148
<ENTRY> lower(text) </ENTRY>
143149
<ENTRY> text </ENTRY>
144150
<ENTRY> convert text to lower case </ENTRY>
@@ -193,6 +199,12 @@ Some are used internally to implement the SQL92 string functions listed above.
193199
<ENTRY> text(varchar 'varchar string') </ENTRY>
194200
</ROW>
195201
<ROW>
202+
<ENTRY> translate(text,from,to) </ENTRY>
203+
<ENTRY> text </ENTRY>
204+
<ENTRY> convert character in string </ENTRY>
205+
<ENTRY> translate('12345', '1', 'a') </ENTRY>
206+
</ROW>
207+
<ROW>
196208
<ENTRY> varchar(char) </ENTRY>
197209
<ENTRY> varchar </ENTRY>
198210
<ENTRY> convert char to varchar type </ENTRY>

‎doc/src/sgml/oper.sgml

Lines changed: 5 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
<Chapter>
1+
<Chapter Id="operators">
22
<Title>Operators</Title>
33

44
<Abstract>
@@ -102,22 +102,22 @@ from numeric types to data/time types.
102102
<ROW>
103103
<ENTRY> ~ </ENTRY>
104104
<ENTRY>Match (regex), case sensitive</ENTRY>
105-
<ENTRY>'thomas' ~ '*.thomas*.'</ENTRY>
105+
<ENTRY>'thomas' ~ '.*thomas.*'</ENTRY>
106106
</ROW>
107107
<ROW>
108108
<ENTRY> ~* </ENTRY>
109109
<ENTRY>Match (regex), case insensitive</ENTRY>
110-
<ENTRY>'thomas' ~* '*.Thomas*.'</ENTRY>
110+
<ENTRY>'thomas' ~* '.*Thomas.*'</ENTRY>
111111
</ROW>
112112
<ROW>
113113
<ENTRY> !~ </ENTRY>
114114
<ENTRY>Does not match (regex), case sensitive</ENTRY>
115-
<ENTRY>'thomas' !~ '*.Thomas*.'</ENTRY>
115+
<ENTRY>'thomas' !~ '.*Thomas.*'</ENTRY>
116116
</ROW>
117117
<ROW>
118118
<ENTRY> !~* </ENTRY>
119119
<ENTRY>Does not match (regex), case insensitive</ENTRY>
120-
<ENTRY>'thomas' !~ '*.vadim*.'</ENTRY>
120+
<ENTRY>'thomas' !~ '.*vadim.*'</ENTRY>
121121
</ROW>
122122
</TBODY>
123123
</TGROUP>

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp