Re: translating this SQL query from a different dialect - Mailing list pgsql-novice

am  10.01.2006, um 15:04:00 -0500 mailte Jaime Casanova folgendes:
> On 1/10/06, A. Kretschmer <andreas.kretschmer@schollglas.com> wrote:
> > am  10.01.2006, um 10:38:59 -0700 mailte Michael Fuhr folgendes:
> > > Beware that as written this doesn't handle concurrency.  For example:
> >
> > Please, can you expand this example that it works with concurrency?
> >
> > This is a new field for me...
> >
>
> and what's the problem with something like
>
> create table foo (
>      fld1   int4   not null unique
>           constraint eight_rows_limit check (fld1 >= 0 and fld1 <= 8)
> );

nice ;-)


Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===