Re: translating this SQL query from a different dialect

From: Jaime Casanova <systemguards(at)gmail(dot)com>
To: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: translating this SQL query from a different dialect
Date: 2006-01-10 20:04:00
Message-ID: c2d9e70e0601101204n76415c01of4b49587aefcf4e8@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On 1/10/06, A. Kretschmer <andreas(dot)kretschmer(at)schollglas(dot)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 ;)

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message A. Kretschmer 2006-01-10 20:11:35 Re: translating this SQL query from a different dialect
Previous Message A. Kretschmer 2006-01-10 20:01:16 Re: translating this SQL query from a different dialect