Postgres 13

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


version


PostgreSQL 13.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.4.1 20200928 (Red Hat 8.4.1-1), 64-bit


CREATE TABLE test
(
  data TEXT NOT NULL,
  
  CONSTRAINT d_csv_only_ck 
    CHECK (data ~ '^([ ]*([1-9]\d*)+[ ]*)(,[ ]*([1-9]\d*)+[ ]*)*$')

);
INSERT INTO test VALUES 
('992,1005,1007,992,456,456,1008'),  -- want to make this line unnacceptable - repeats!
('44,1005,1110'), 
('13,  44  ,  1005,  10078  '),  -- acceptable - spaces before and after integers   
('11,1203,6666'),
('1,11,99,2222'),
('3435'),             
('  1234    '); -- acceptable
7 rows affected

INSERT INTO test VALUES ('23432, 3433   ,00343, 567'); -- leading 0 - unnacceptabgle
ERROR:  new row for relation "test" violates check constraint "d_csv_only_ck"
DETAIL:  Failing row contains (23432, 3433   ,00343, 567).


INSERT INTO test VALUES ('12  34');  -- spaces within numbers - unnacceptable
ERROR:  new row for relation "test" violates check constraint "d_csv_only_ck"
DETAIL:  Failing row contains (12  34).


SELECT * FROM test;


data


992,1005,1007,992,456,456,1008

44,1005,1110

13,  44  ,  1005,  10078

11,1203,6666

1,11,99,2222

3435

  1234


CREATE TABLE x 
(
  y TEXT

  CONSTRAINT x_repeats_ck CHECK (y ~ '(\b\d+\b)(?=.*\b\1\b)')  
  
);
INSERT INTO x VALUES ('xxxx, yere, slslls, xxxx, aaaa'); -- xxxx matches
ERROR:  invalid regular expression: invalid backreference number


INSERT INTO x VALUES ('x, y, z');  -- no match!
ERROR:  invalid regular expression: invalid backreference number