On Tue, Jul 06, 2010 at 12:55:22PM +0100, Andre Lopes wrote: > update aau_utilizadores > set group_id = 3 > where email = pEMAIL; [..] > If I use the clause WHERE only in "id" will not work fot both cases, or will > work? Yes, it'll do the "right thing". OLD always refers to the previous version of the row and NEW refers to the new version of the row, you can use as many or few of the columns as you want. -- Sam http://samason.me.uk/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
