Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: CHECK-Constraint mit WHERE ?
- From: Martin Spott <Martin(dot)Spott(at)mgras(dot)net>
- To: pgsql-de-allgemein(at)postgresql(dot)org
- Subject: Re: CHECK-Constraint mit WHERE ?
- Date: Thu, 22 Jun 2006 22:52:51 +0000 (UTC)
Christoph Lamprecht wrote: > Martin Spott <Martin(dot)Spott(at)mgras(dot)net> schrieb am 22.06.2006 15:58:26: >> CONSTRAINT enforce_covertype CHECK ( >> (geomtype LIKE 'POLYGON%' AND (covertype >= 0 AND covertype < 6)) >> OR geomtype NOT LIKE 'POLYGON%' >> ) > geht das nicht einfacher: > > CONSTRAINT enforce_covertype CHECK ( > geomtype NOT LIKE 'POLYGON%' > OR (covertype >= 0 AND covertype < 6) > ) Stimmt, leuchtet ein - und hat den selben Effekt, Martin. -- Unix _IS_ user friendly - it's just selective about who its friends are ! --------------------------------------------------------------------------
- References:
- Re: CHECK-Constraint mit WHERE ?
- From: Christoph Lamprecht
- Re: CHECK-Constraint mit WHERE ?
- Prev by Date: Re: CHECK-Constraint mit WHERE ?
- Next by Date: Re: Problem mit Starten des "PostgreSQL Database Server 8.1" Dienstes
- Previous by thread: Re: CHECK-Constraint mit WHERE ?
- Next by thread: Materialized Views
- Indexes: