Re: sugsestions

On Tue, 2003-07-08 at 21:31, ivan wrote:
> What do you think about :
>
> 1. OPTION RETURNS NULL ON NULL INPUT (when function is created) change to
>   RETURNS <val> ON NULL INPUT .... ???

I personally think this should be up to the specific function to
capture.  This way it could be a complex result.

> 2. CREATE TYPE .. with  INHERITS (..) like in CREATE TABLE
>  but type should be normaly with including base type
>  create type A AS (A INT,B INT);
> and
>  create type B AS (C INT, D INT) INHERITS( A ); ==
>  create type B AS (A INT, B INT, C INT, D INT );
>  can be ??

I like this.  The equivalent table syntax for absorbing table structure
into another table is LIKE:

CREATE TABLE othertable (acol integer);
CREATE TABLE a (col integer, LIKE othertable, anothercol integer);

I could see:

CREATE TYPE a AS (a integer, b integer);
CREATE TYPE b AS (LIKE a, c integer, d integer);

> 5. What do you think about crontab in postgres database , like pg_crontab
>   ?

This has been debated several times.  Each time it has ended with
standard cron being the best solution for cron.