On Tue, Mar 15, 2005 at 05:43:15PM +0000, John Smith wrote:
> 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"
Is that the *exact* command you're running? The word CREATE is
misspelled, although that should give a different error:
CREAYE TYPE product AS (name varchar, price numeric);
ERROR: syntax error at or near "CREAYE" at character 1
LINE 1: CREAYE TYPE product AS (name varchar, price numeric);
^
If that's not the actual command, then please copy and paste what
you're really doing.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/