Hi,
Thanks for the reply.
In the application there are two kinds of UPDATES to this table.
[code]
update aau_utilizadores
set group_id = 3
where email = pEMAIL;
[/code]
and
[code]
update aau_utilizadores
set password = 3
where id = pNEWPASSWORD;
[/code]
If I use the clause WHERE only in "id" will not work fot both cases, or will
work?
Best Regards,
On Tue, Jul 6, 2010 at 12:46 PM, Sam Mason <s...@samason.me.uk> wrote:
> On Tue, Jul 06, 2010 at 12:28:35PM +0100, Andre Lopes wrote:
> > Ok, I have done the UPDATE RULE like this and works!
>
> > where
> > (id = OLD.id or username = OLD.username or email = OLD.email)
>
> I'm pretty sure you just want to be using the id column above. Using an
> OR expression as you're doing could have some strange side effects.
>
> You may also want to consider a UNIQUE constraint on the username (and
> maybe email) fields as well, especially as you've said they should be
> able to be used to uniquely determine a user.
>
> --
> Sam http://samason.me.uk/
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
