From: | Thomas Good <tomg(at)sqlclinic(dot)net> |
---|---|
To: | PostgreSQL SQL List <pgsql-sql(at)postgreSQL(dot)org> |
Subject: | CHECK CONSTRAINT blunder(s) |
Date: | 2002-05-14 20:50:20 |
Message-ID: | Pine.LNX.4.05.10205141642320.13091-100000@admin.nrnet.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi,
Can someone clue me in as to proper syntax for adding a not null
check constraint? I've fumbled around a bit without much luck
and I don't see this covered in the alter table section of the
interactive docs.
My pseudo code is:
ALTER TABLE doof ADD CONSTRAINT bleibt_doof NOT NULL (record_id);
But obviously this fails.
TIA - Cheers
-----------------------------------------------------------------------
Thomas Good e-mail: tomg(at)sqlclinic(dot)net
Programmer/Analyst phone: (+1) 718.818.5528
Residential Services fax: (+1) 718.818.5056
Behavioral Health Services, SVCMC-NY mobile: (+1) 917.282.7359
-- --
SQL Clinic - An Open Source Clinical Record www.sqlclinic.net
------------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Joel Burton | 2002-05-14 21:20:20 | Re: can't cast varchar as integer? |
Previous Message | Tom Lane | 2002-05-14 20:13:17 | Re: aggregate... |