Postgres Pro
Downloads
Home   >   mailing lists

Re: ALTER TABLE TODO items - Mailing list pgsql-hackers

From Tom Lane
Subject Re: ALTER TABLE TODO items
Date
Msg-id 8274.1083779944@sss.pgh.pa.us
Whole thread Raw
In response to ALTER TABLE TODO items  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: ALTER TABLE TODO items  (Richard Huxton <dev@archonet.com>)
Re: ALTER TABLE TODO items  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-hackers
Tree view 
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Wow, you can reference different column as part of the alter column.

Yeah, the USING is actually any arbitrary expression over the old table
row.  (Getting that to work was a tad tricky...)  So you can view this
as a full-table UPDATE operation that folds in possible column type changes.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Manfred Koizar
Date:
Subject: Re: Multiple Xids in PGPROC?
Next
From: Bruce Momjian
Date:
Subject: Re: ALTER TABLE TODO items