>David Greco wrote: >[wants to use CTEs in an UPDATE] >> Yeah that's good, but there are plenty of columns, was hoping to be able to use (table.*) syntax >Is this a problem or do you just want to type as little as possible? >You have to specify them in the SET clause anyway. No problem, just looking to be a bit lazy, and avoid the potential for copy-paste errors and such. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general