Missing doc on expression format for ALTER TABLE

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-docs(at)postgresql(dot)org
Subject: Missing doc on expression format for ALTER TABLE
Date: 2005-03-27 00:55:25
Message-ID: 200503261655.25658.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

Folks,

I've noticed that this statement is missing something:

(from sql-altertable.sgml):

ALTER COLUMN TYPE

This form changes the type of a column of a table. Indexes and simple table
constraints involving the column will be automatically converted to use the
new column type by reparsing the originally supplied expression. The optional
USING clause specifies how to compute the new column value from the old; if
omitted, the default conversion is the same as an assignment cast from old
data type to new. A USING clause must be provided if there is no implicit or
assignment cast from old to new type.

... nowhere in this file (or anywhere else that I can tell) is the syntax for
the USING expression defined.

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Tom Lane 2005-03-27 04:47:59 Re: Missing doc on expression format for ALTER TABLE
Previous Message Josh Berkus 2005-03-25 03:19:00 Re: [PATCHES] Approximate count(*)