ALTER TABLE ... SET DATA TYPE (SQL:2008)

Started by Peter Eisentrautover 17 years ago1 messageshackers
Jump to latest
#1Peter Eisentraut
peter_e@gmx.net

Here is a patch that allows the new SQL:2008 syntax (also used by IBM)

ALTER TABLE tab ALTER COLUMN col SET DATA TYPE typ

alongside our current syntax

ALTER TABLE tab ALTER COLUMN col TYPE typ

I verified that we implement a superset what the standard says. (Of
course, the standard doesn't suport the USING clause.)

There was some key word overlap with ecpg, so the patch looks bulkier
than it really is.

Attachments:

alter-set-data-type.difftext/plain; name=alter-set-data-type.diff; x-mac-creator=0; x-mac-type=0Download+71-27