|
1 | 1 | <!-- |
2 | | -$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.182 2003/12/16 15:27:58 petere Exp $ |
| 2 | +$PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.183 2003/12/18 03:59:07 momjian Exp $ |
3 | 3 | PostgreSQL documentation |
4 | 4 | --> |
5 | 5 |
|
@@ -3134,7 +3134,10 @@ substring('foobar' from 'o(.)b') <lineannotation>o</lineannotation> |
3134 | 3134 | <note> |
3135 | 3135 | <para> |
3136 | 3136 | Keep in mind that an escape's leading <literal>\</> will need to be |
3137 | | - doubled when entering the pattern as an SQL string constant. |
| 3137 | + doubled when entering the pattern as an SQL string constant. For example: |
| 3138 | +<programlisting> |
| 3139 | +'123' ~ '^\\d{3}' <lineannotation>true</lineannotation> |
| 3140 | +</programlisting> |
3138 | 3141 | </para> |
3139 | 3142 | </note> |
3140 | 3143 |
|
|