Re: A VIEW mimicing a TABLE

From: "SunWuKung" <Balazs(dot)Klein(at)t-online(dot)hu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: A VIEW mimicing a TABLE
Date: 2006-12-14 10:45:12
Message-ID: 1166093112.494128.149730@n67g2000cwd.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Luca Ferrari 2006-12-14 11:12:32 unix/linux administration tools
Previous Message Rafal Pietrak 2006-12-14 10:32:22 Re: A VIEW mimicing a TABLE