Re: [pgsql-es-ayuda] error en varios editores sql

2015-02-12 Por tema Gilberto Castillo
> Hola amigos... > > tengo este codigo sql > CREATE TABLE public.fruits_in_stock( > NAME INTEGER PRIMARY KEY, > in_stock INTEGER NOT NULL, > reserved INTEGER NOT NULL DEFAULT 0, > CHECK(in_stock BETWEEN 0 AND 1000), > CHECK(reserved <= in_stock) > ); > > CREATE TABLE public.fruits_offer( >

[pgsql-es-ayuda] error en varios editores sql

2015-02-12 Por tema Freddy Martinez Garcia
Hola amigos... tengo este codigo sql CREATE TABLE public.fruits_in_stock( NAME INTEGER PRIMARY KEY, in_stock INTEGER NOT NULL, reserved INTEGER NOT NULL DEFAULT 0, CHECK(in_stock BETWEEN 0 AND 1000), CHECK(reserved <= in_stock) ); CREATE TABLE public.fruits_offer( offer_id SERIAL PRIMARY K