Skip site navigation (1) Skip section navigation (2)

test CHECK on command line

From: "Jean-Yves F(dot) Barbier" <12ukwn(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: test CHECK on command line
Date: 2011-06-17 04:12:03
Message-ID: 20110617061203.0ed54456@anubis.defcon1 (view raw or flat)
Thread:
Lists: pgsql-novice
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."

Responses

pgsql-novice by date

Next:From: Jean-Yves F. BarbierDate: 2011-06-17 07:56:43
Subject: change p/w hashing
Previous:From: Oliveiros d'Azevedo CristinaDate: 2011-06-16 13:56:00
Subject: Re: Backing Up ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group