public inbox for [email protected]  

help / color / mirror / Atom feed

From: Josh Berkus <[email protected]>
To: [email protected]
Subject: Missing doc on expression format for ALTER TABLE
Date: Sat, 26 Mar 2005 16:55:25 -0800
Message-ID: <[email protected]> (raw)

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

view thread (6+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: Missing doc on expression format for ALTER TABLE
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox