Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <pgsql-sql-owner+archive@lists.postgresql.org>)
	id 1ek6m1-00035E-3A
	for pgsql-sql@arkaria.postgresql.org; Fri, 09 Feb 2018 11:23:21 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from <pgsql-sql-owner+archive@lists.postgresql.org>)
	id 1ek6lz-0006Us-Lj
	for pgsql-sql@arkaria.postgresql.org; Fri, 09 Feb 2018 11:23:19 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.84_2)
	(envelope-from <achill@matrix.gatewaynet.com>)
	id 1ek6lz-0006UZ-FQ
	for pgsql-sql@lists.postgresql.org; Fri, 09 Feb 2018 11:23:19 +0000
Received: from host3.dynacom.ondsl.gr ([62.103.35.211]
 helo=smadev.internal.net)
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.89)
	(envelope-from <achill@matrix.gatewaynet.com>)
	id 1ek6lw-0006Rh-Gu
	for pgsql-sql@lists.postgresql.org; Fri, 09 Feb 2018 11:23:19 +0000
Received: from smadev.internal.net (smadev [10.9.200.131])
	by smadev.internal.net (8.15.2/8.15.2) with ESMTP id w19BNA6c019619
	for <pgsql-sql@lists.postgresql.org>; Fri, 9 Feb 2018 13:23:11 +0200 (EET)
	(envelope-from achill@matrix.gatewaynet.com)
Subject: Re: functions allowed in CHECK constraints
To: pgsql-sql@lists.postgresql.org
References: <1159df36-5e6b-a433-e9b7-5d197f820f56@matrix.gatewaynet.com>
From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
Message-ID: <5cc219d4-197e-bb24-e883-e1668fdfd7a2@matrix.gatewaynet.com>
Date: Fri, 9 Feb 2018 13:23:10 +0200
User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:52.0) Gecko/20100101
 Thunderbird/52.5.2
MIME-Version: 1.0
In-Reply-To: <1159df36-5e6b-a433-e9b7-5d197f820f56@matrix.gatewaynet.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Content-Language: en-US
List-Id: <pgsql-sql.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-sql@lists.postgresql.org>
List-Owner: <mailto:pgsql-sql-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-sql>
Precedence: bulk

On 09/02/2018 11:04, Achilleas Mantzios wrote:
> Hello,
well it seems the intuition by reading the docs was correct, although not exactly explicit. A Trigger is the way to do this.
> ....



-- 
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt