Re: trigger or something else?

>>>>> "EK" == Emils Klotins <emils@dot.lv> writes:
EK> Hello,EK> I have a table that has to have several fields with different names, EK> but equal content. Sounds
stupid,but it is because I have 2 EK> different programs querying the same table for user information and EK> each of
themuses differently named fields.
 
EK> Eg. I have fields passwd and password.EK> When passwd field changes, password must automatically change EK> to be
thesame as passwd.
 
EK> I was wondering whether I need a trigger for that, or could I EK> somehow manage to specify that in the "create
table"stmt.
 
EK> If I need to do it via trigger, then I apparently need the plpgsql, right?EK> Could you tell which configure option
enablesthat? --enable-EK> plpgsql? 
 
EK> Thanks in advamce for any comments.
EK> Emils

I suppose you can use view for your need. For example:

create table a ( l varchar(30), p varchar(30)
);

create view b as select l as login, p as password from a;

insert into a values ('qq', 'ww');
select * from b;
tolik=# select * from b;login | password 
-------+----------qq    | ww
(1 rows)


Unfortunately this way suits for select only, not for 'insert into b'
and 'update b' statement.

-- 
Anatoly K. Lasareff              Email:       tolik@aaanet.ru