Re: A VIEW mimicing a TABLE - Mailing list pgsql-general

From SunWuKung
Subject Re: A VIEW mimicing a TABLE
Date
Msg-id 1166093112.494128.149730@n67g2000cwd.googlegroups.com
Whole thread Raw
In response to Re: A VIEW mimicing a TABLE  ("William Leite Araújo" <william.bh@gmail.com>)
Responses Re: A VIEW mimicing a TABLE  (Rafal Pietrak <rafal@zorro.isa-geek.com>)
Re: A VIEW mimicing a TABLE  ("William Leite Araújo" <william.bh@gmail.com>)
List pgsql-general
> CREATE RULE new_entry AS ON INSERT to logview DO INSTEAD INSERT
>    (id,tm,info) VALUES (COALESCE(new.id,[default]),COALESCE(new.tm
> ,[default]),COALESCE(new.info,[default]));

what would [default] insert here?
the default of the view or the default of the underlying table?

B.


pgsql-general by date:

Previous
From: Rafal Pietrak
Date:
Subject: Re: A VIEW mimicing a TABLE
Next
From: Luca Ferrari
Date:
Subject: unix/linux administration tools