Postgres 15

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();


version


PostgreSQL 15beta2 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-10), 64-bit


select regexp_replace(
E'In most cases regexp_matches() should be used with the g flag,' ||
E'since if you only want\n the first match, it''s easier and more efficient'||
E'to use regexp_match(). \nHowever, regexp_match() only exists in '||
E'PostgreSQL version 10 and up. When working in older\n versions,' ||
E'a common trick is to place a regexp_matches() call in a sub-select,'||
E'for\n example:', '(\s\n).*?(PostgreSQL version 10)(.*?(\n\s)){1}', '|');


regexp_replace


In most cases regexp_matches() should be used with the g flag,since if you only want
 the first match, it's easier and more efficientto use regexp_match().|versions,a common trick is to place a regexp_matches() call in a sub-select,for
 example:


select regexp_replace(
E'In most cases regexp_matches() should be used with the g flag,' ||
E'since if you only want\n the first match, it''s easier and more efficient'||
E'to use regexp_match(). \nHowever, regexp_match() only exists in '||
E'PostgreSQL version 10 and up. When working in older\n versions,' ||
E'a common trick is to place a regexp_matches() call in a sub-select,'||
E'for\n example:', '(\s\n).*?(PostgreSQL version 10)(.*?(\n\s)){2}', '|');


regexp_replace


In most cases regexp_matches() should be used with the g flag,since if you only want
 the first match, it's easier and more efficientto use regexp_match().|example:


select count(*) from
(select regexp_replace(
E'In most cases regexp_matches() should be used with the g flag,' ||
E'since if you only want\n the first match, it''s easier and more efficient'||
E'to use regexp_match(). \nHowever, regexp_match() only exists in '||
E'PostgreSQL version 10 and up. When working in older\n versions,' ||
E'a common trick is to place a regexp_matches() call in a sub-select,'||
E'for\n example:', '(\s\n).*?(PostgreSQL version 10)(.*?(\n\s)){2}', '|')
except
select regexp_replace(
E'In most cases regexp_matches() should be used with the g flag,' ||
E'since if you only want\n the first match, it''s easier and more efficient'||
E'to use regexp_match(). \nHowever, regexp_match() only exists in '||
E'PostgreSQL version 10 and up. When working in older\n versions,' ||
E'a common trick is to place a regexp_matches() call in a sub-select,'||
E'for\n example:', '(\s\n).*?(PostgreSQL version 10)(.*?(\n\s)){1}', '|')
)a;


count


1