Conditional constraint?

From: Nick Haw <nick(dot)haw(at)operagrp(dot)com>
To: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>, "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>, "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>, "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>
Subject: Conditional constraint?
Date: 2002-03-08 17:06:57
Message-ID: 71F468541618D3118DDF204C4F4F50204B1EC9@ThisAddressDoesNotExist
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

Hi there, I have a problem that I can't fathom out.

What I want to do is make a field so that it requires a value after a change
in another field to a particular value. Is this possible with the ADD
CONSTRAINT command, or will I have to make a custom function and use a
trigger.

Many thanks

Nick

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Emberson 2002-03-08 17:14:38 which JDBC driver
Previous Message Francisco Reyes 2002-03-08 16:50:30 Re: Is vacuum full lock like old's vacuum's lock?

Browse pgsql-novice by date

  From Date Subject
Next Message Robert J. Sanford, Jr. 2002-03-08 18:05:19 Re: Good tutorial wanted...
Previous Message Patrick Hatcher 2002-03-08 17:01:48 FATAL 1: Database template0 not accepting connection?