The following bug has been logged online:
Bug reference: 1547
Logged by: John Smith
Email address: johnsmit89(at)hotmail(dot)com
PostgreSQL version: 8.0
Operating system: Windows 2000
Description: CREATE TYPE AS error
Details:
When trying to create a complex type, the parser produces an error. e.g.
CREAYE TYPE product AS (name varchar, price numeric);
produces
ERROR: parser: parse error at or near "as"