Hello,
I have a paranoic question.
In PostgreSQL 8.4.7 I had a table to store started, completed and
interrupted games :
# \d pref_match
Table public.pref_match
Column | Type |Modifiers
On Thu, Feb 24, 2011 at 07:30:32PM +0100, Alexander Farber wrote:
Shouldn't the line
pref_match_check CHECK (completed = win AND win = 0)
above actually be:
pref_match_win_check CHECK (completed = win AND win = 0)
? Does it indicate something went wrong or is it just cosmetic
.
David J.
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Alexander Farber
Sent: Thursday, February 24, 2011 1:31 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Adding a column with constraint
Hello,
I have
On Thu, Feb 24, 2011 at 8:02 PM, David Johnston pol...@yahoo.com wrote:
A column constraint can only reference its own column. Since you are
referencing completed in the CHECK it implicitly converts the Column
constraint into a Table constraint - and table constraints do not reference
the