>>>>> "EK" == Emils Klotins <[EMAIL PROTECTED]> 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 them uses differently named fields.
EK> Eg. I have fields passwd and password.
EK> When passwd field changes, password must automatically change
EK> to be the same 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 enables that? --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: [EMAIL PROTECTED]
