Re: translating this SQL query from a different dialect

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)
);

--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)