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/ ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org