table alias for update - Mailing list pgsql-general

From hamann.w@t-online.de
Subject table alias for update
Date
Msg-id wolfgang-1120325091653.A0228608@amadeus3.local
Whole thread Raw
Responses Re: table alias for update  (Bosco Rama <postgres@boscorama.com>)
List pgsql-general

is there a way to use a table alias for the target table in an UPDATE query?
I would like to avoid spelling out things like that in psql:

update myverylongtablename set col1 = r.col1repl from repltable r
 where myverylongtablename.id = r.id and myverylongtablename.col2 > 0

Regards
Wolfgang Hamann


pgsql-general by date:

Previous
From: hamann.w@t-online.de
Date:
Subject: can these queries be combined into one?
Next
From: Bosco Rama
Date:
Subject: Re: table alias for update