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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
