Oracle- Check datetime

[Honza Pazdziora]

On Wed, Oct 29, 2003 at 09:18:35AM +0100, Karel Zak wrote:
> 
>  Mala exkurze do sveta PostgreSQL (ja vim uz mama rikala, ze zlobim:-)

Chachaaa. Dobrej priklad.

> # CREATE FUNCTION aaa( int ) RETURNS bool AS 
>     'SELECT CASE WHEN $1 > 130 THEN ''f''::bool ELSE ''t''::bool END;' 
>   LANGUAGE 'SQL';
> 
> # CREATE TABLE tab (age int CHECK (aaa( age )));
> 
> # INSERT INTO tab VALUES (1);
> INSERT 17149 1


# INSERT INTO tab VALUES (125);
INSERT 83686 1


> # INSERT INTO tab VALUES (150);
> ERROR:  new row for relation "tab" violates CHECK constraint "tab_age"
> 
> # DROP FUNCTION aaa( int );
> NOTICE:  constraint tab_age on table tab depends on function aaa(integer)
> ERROR:  cannot drop function aaa(integer) because other objects depend on it
> 
> 
> # CREATE OR REPLACE FUNCTION aaa( int ) RETURNS bool AS 
>     'SELECT CASE WHEN $1 > 120  THEN ''f''::bool ELSE ''t''::bool END;' 
>   LANGUAGE 'SQL';
> 
> # INSERT INTO tab VALUES (120);
> INSERT 17150 1
> 
> # INSERT INTO tab VALUES (121);
> ERROR:  new row for relation "tab" violates CHECK constraint "tab_age"


# select * from tab ;
 age 
 -----
   1
 125
 120
(3 rows)

Prijde mi divne, ze v tabulce mam hodnotu 125, kdyz nad tou tabulkou
je check, kde je jasne receno, ze 120 je limit.

:-))

-- 
------------------------------------------------------------------------
 Honza Pazdziora | adelton na fi.muni.cz | http://www.fi.muni.cz/~adelton/
 .project: Perl, mod_perl, DBI, Oracle, auth. WWW servers, XML/XSL, ...
		Only self-confident people can be simple.