|
1 | 1 | <!-- |
2 | | -$Header: /cvsroot/pgsql/doc/src/sgml/func.sgml,v 1.126 2002/09/24 20:14:58 petere Exp $ |
| 2 | +$Header: /cvsroot/pgsql/doc/src/sgml/func.sgml,v 1.127 2002/10/05 19:03:16 momjian Exp $ |
3 | 3 | PostgreSQL documentation |
4 | 4 | --> |
5 | 5 |
|
@@ -491,11 +491,11 @@ PostgreSQL documentation |
491 | 491 | <entry>01110</entry> |
492 | 492 | </row> |
493 | 493 | <row> |
494 | | - <entry>B'10001'<< 3</entry> |
| 494 | + <entry>B'10001'<< 3</entry> |
495 | 495 | <entry>01000</entry> |
496 | 496 | </row> |
497 | 497 | <row> |
498 | | - <entry>B'10001'>> 2</entry> |
| 498 | + <entry>B'10001'>> 2</entry> |
499 | 499 | <entry>00100</entry> |
500 | 500 | </row> |
501 | 501 | </tbody> |
@@ -2726,7 +2726,7 @@ SUBSTRING('foobar' FROM 'o(.)b') <lineannotation>o</lineannotation> |
2726 | 2726 |
|
2727 | 2727 | <para> |
2728 | 2728 | There are two special cases of bracket expressions: the bracket |
2729 | | - expressions <literal>[[:<:]]</literal> and |
| 2729 | + expressions <literal>[[:<:]]</literal> and |
2730 | 2730 | <literal>[[:>:]]</literal> match the null string at the beginning |
2731 | 2731 | and end of a word respectively. A word is defined as a sequence |
2732 | 2732 | of word characters which is neither preceded nor followed by word |
@@ -3277,11 +3277,11 @@ SUBSTRING('foobar' FROM 'o(.)b') <lineannotation>o</lineannotation> |
3277 | 3277 | </row> |
3278 | 3278 | <row> |
3279 | 3279 | <entry><literal>MI</literal></entry> |
3280 | | -<entry>minus sign in specified position (if number< 0)</entry> |
| 3280 | +<entry>minus sign in specified position (if number< 0)</entry> |
3281 | 3281 | </row> |
3282 | 3282 | <row> |
3283 | 3283 | <entry><literal>PL</literal></entry> |
3284 | | -<entry>plus sign in specified position (if number> 0)</entry> |
| 3284 | +<entry>plus sign in specified position (if number> 0)</entry> |
3285 | 3285 | </row> |
3286 | 3286 | <row> |
3287 | 3287 | <entry><literal>SG</literal></entry> |
@@ -4293,13 +4293,18 @@ SELECT timeofday(); |
4293 | 4293 | </informalexample> |
4294 | 4294 |
|
4295 | 4295 | <para> |
4296 | | - It isquiteimportant to realize that |
4297 | | - <function>CURRENT_TIMESTAMP</function> and related functionsallreturn |
4298 | | - thetime as of thestart of the current transaction; their values do not |
4299 | | -increment while a transaction is running. But |
4300 | | -<function>timeofday()</function>returns theactual current time. |
| 4296 | + It is important to realize that |
| 4297 | + <function>CURRENT_TIMESTAMP</function> and related functions return |
| 4298 | + the start time of the current transaction; their values do not |
| 4299 | +change during the transaction. <function>timeofday()</function> |
| 4300 | + returns thewall clock time and does advance during transactions. |
4301 | 4301 | </para> |
4302 | 4302 |
|
| 4303 | + <note> |
| 4304 | + Many other database systems advance these values more |
| 4305 | + frequently. |
| 4306 | + </note> |
| 4307 | + |
4303 | 4308 | <para> |
4304 | 4309 | All the date/time data types also accept the special literal value |
4305 | 4310 | <literal>now</literal> to specify the current date and time. Thus, |
|