trigger or something else?

From: "Emils Klotins" <emils(at)dot(dot)lv>
To: pgsql-sql(at)postgresql(dot)org
Subject: trigger or something else?
Date: 2000-06-28 10:29:24
Message-ID: 3959EFA4.13956.28AD4E96@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello,

I have a table that has to have several fields with different names,
but equal content. Sounds stupid, but it is because I have 2
different programs querying the same table for user information and
each of them uses differently named fields.

Eg. I have fields passwd and password.
When passwd field changes, password must automatically change
to be the same as passwd.

I was wondering whether I need a trigger for that, or could I
somehow manage to specify that in the "create table" stmt.

If I need to do it via trigger, then I apparently need the plpgsql, right?
Could you tell which configure option enables that? --enable-
plpgsql?

Thanks in advamce for any comments.

Emils

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Karel Zak 2000-06-28 10:52:40 Re: trigger or something else?
Previous Message David Craig 2000-06-28 10:19:14 extracting a table description