Home > mailing lists

test CHECK on command line - Mailing list pgsql-novice

From	Jean-Yves F. Barbier
Subject	test CHECK on command line
Date	June 17, 2011 04:12:16
Msg-id	20110617061203.0ed54456@anubis.defcon1 Whole thread Raw
Responses	Re: test CHECK on command line (Josh Kupershmidt <schmiddy@gmail.com>)
List	pgsql-novice

Tree view

Hi list,

I'm trying to test CHECK constraints on command line but I miss something:

SELECT '1234567890123' ~ 'CHECK(char_length(VALUE) = 13)';

always return FALSE :(

JY
--
    "What did you do when the ship sank?"
    "I grabbed a cake of soap and washed myself ashore."

pgsql-novice by date:

From: "Oliveiros d'Azevedo Cristina"
Date: 16 June 2011, 13:56:33
Subject: Re: Backing Up ?

From: "Jean-Yves F. Barbier"
Date: 17 June 2011, 07:56:54
Subject: change p/w hashing

test CHECK on command line - Mailing list pgsql-novice

Previous

Next