Re: [SQL] constraint with check

2010-12-13 Thread Jasen Betts
On 2010-12-13, Viktor Bojović wrote: > --0015175cd20209e2030497532e39 > Content-Type: text/plain; charset=UTF-8 > Content-Transfer-Encoding: quoted-printable > > Hi > im trying to create foreign key constraint which checks not only the > existence of key in foreign table, but it has to check if no

[SQL] constraint with check

2010-12-13 Thread Viktor Bojović
Hi im trying to create foreign key constraint which checks not only the existence of key in foreign table, but it has to check if node field has value=true but i don't know how to do that, so im asking for help. alter table wg.nc add CONSTRAINT "nc_fk" FOREIGN KEY ("Id1") REFERENCES "wg"."entiti