Ooops! Hit send too fast...
On 08/22/12 15:34, Bosco Rama wrote:
> On 08/22/12 15:19, Gauthier, Dave wrote:
>>
>> I know a view can be used to alias one of them.
>
> It can alias all of them:
>
> create view xyz as
> select *, last_name as lname, last_name as surname
> from mytable;
>
> (not the nicest version but functional)
... and then use an INSTEAD/ALSO rule to do the update, if needed.
Bosco.
