Re: OLD pseudo relation for INSERT in rules and triggers

W dniu 01/01/2013 07:24 PM, Adrian Klaver pisze:
> On 01/01/2013 10:17 AM, Rafał Pietrak wrote:
>
[---------------]
>> If not, I think having OLD.* in INSERT rules/triggers is worth
>> pondering.
>>
>> The thing is, that it would be a valuable tool to mimic table-propper
>> functionality by a view. The OLD.* preudorelation on INSERT could
>> provide column defaults from the underlaying table definition.
[----------------]
>
> http://www.postgresql.org/docs/9.2/interactive/sql-alterview.html
>
> "SET/DROP DEFAULT
> These forms set or remove the default value for a column. A default
> value associated with a view column is inserted into INSERT statements
> on the view before the view's ON INSERT rule is applied, if the INSERT
> does not specify a value for the column."

Aha. I felt, I was missing something.

> It is not quite the same, but close.
>
It's not the same, as one has to keep track of the default value for one
thing in two places; but it's surely better then nothing (as I thought,
was the case).

thenx again,

-R