add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
CREATE TABLE TEST_TABLE AS
SELECT 'foo.com' AS EMAIL
SELECT 1
SELECT *
FROM TEST_TABLE
email
foo.com 
SELECT 1
SELECT regexp_matches(email, '(\w+)\.\w+$')
FROM TEST_TABLE
regexp_matches
{foo} 
SELECT 1
SELECT (regexp_matches(email, '(\w+)\.\w+$'))[1]
FROM TEST_TABLE
regexp_matches
foo 
SELECT 1
SELECT regexp_matches(email, '\w+\.(\w+)$')
FROM TEST_TABLE
regexp_matches
{com} 
SELECT 1
SELECT (regexp_matches(email, '\w+\.(\w+)$'))[1]
FROM TEST_TABLE
regexp_matches
com 
SELECT 1
SELECT regexp_matches(email, '((\w+)\.\w+$)')
FROM TEST_TABLE
regexp_matches
{foo.com,foo} 
SELECT 1
SELECT (regexp_matches(email, '((\w+)\.\w+$)'))[1]
FROM TEST_TABLE
regexp_matches
foo.com 
SELECT 1
SELECT (regexp_matches(email, '((\w+)\.\w+$)'))[2]
FROM TEST_TABLE
regexp_matches
foo 
SELECT 1
SELECT regexp_matches(email, '(\w+\.(\w+)$)')
FROM TEST_TABLE
regexp_matches
{foo.com,com} 
SELECT 1
SELECT (regexp_matches(email, '(\w+\.(\w+)$)'))[1]
FROM TEST_TABLE
regexp_matches
foo.com 
SELECT 1
SELECT (regexp_matches(email, '(\w+\.(\w+)$)'))[2]
FROM TEST_TABLE
regexp_matches
com 
SELECT 1