@@ -3426,7 +3426,7 @@ SELECT NOT(ROW(table.*) IS NOT NULL) FROM TABLE; -- detect at least one null in
34263426 <primary>regexp_replace</primary>
34273427 </indexterm>
34283428 <function>regexp_replace</function> ( <parameter>string</parameter> <type>text</type>, <parameter>pattern</parameter> <type>text</type>, <parameter>replacement</parameter> <type>text</type>
3429- [ , <parameter>flags</parameter> <type>text</type>
] )
3429+ <optional> , <parameter>flags</parameter> <type>text</type>
</optional> )
34303430 <returnvalue>text</returnvalue>
34313431 </para>
34323432 <para>
@@ -3445,8 +3445,8 @@ SELECT NOT(ROW(table.*) IS NOT NULL) FROM TABLE; -- detect at least one null in
34453445 <entry role="func_table_entry"><para role="func_signature">
34463446 <function>regexp_replace</function> ( <parameter>string</parameter> <type>text</type>, <parameter>pattern</parameter> <type>text</type>, <parameter>replacement</parameter> <type>text</type>,
34473447 <parameter>start</parameter> <type>integer</type>
3448- [ , <parameter>N</parameter> <type>integer</type>
3449- [ , <parameter>flags</parameter> <type>text</type>
] ] )
3448+ <optional> , <parameter>N</parameter> <type>integer</type>
3449+ <optional> , <parameter>flags</parameter> <type>text</type>
</optional> </optional> )
34503450 <returnvalue>text</returnvalue>
34513451 </para>
34523452 <para>
@@ -6117,13 +6117,13 @@ SELECT col1, (SELECT regexp_matches(col2, '(bar)(beque)')) FROM tab;
61176117 It has the syntax
61186118 <function>regexp_replace</function>(<replaceable>string</replaceable>,
61196119 <replaceable>pattern</replaceable>, <replaceable>replacement</replaceable>
6120- <optional>, <replaceable>start</replaceable>
6120+ <optional>, <replaceable>flags</replaceable> </optional>)
6121+ or
6122+ <function>regexp_replace</function>(<replaceable>string</replaceable>,
6123+ <replaceable>pattern</replaceable>, <replaceable>replacement</replaceable>,
6124+ <replaceable>start</replaceable>
61216125 <optional>, <replaceable>N</replaceable>
6122- </optional></optional>
6123- <optional>, <replaceable>flags</replaceable> </optional>).
6124- (Notice that <replaceable>N</replaceable> cannot be specified
6125- unless <replaceable>start</replaceable> is,
6126- but <replaceable>flags</replaceable> can be given in any case.)
6126+ <optional>, <replaceable>flags</replaceable> </optional></optional>).
61276127 The source <replaceable>string</replaceable> is returned unchanged if
61286128 there is no match to the <replaceable>pattern</replaceable>. If there is a
61296129 match, the <replaceable>string</replaceable> is returned with the