Piergiorgio Buongiovanni wrote:
> I'm using Query Tool of pgAdmin III and trying to execute this:
>
> CREATE TYPE business.EuropeanCEFLevel AS ENUM
> ('A1','A2','B1','B2','C1','C2');
>
> but the following error is raised:
>
> ERROR: syntax error at or near "ENUM"
> LINE 1: CREATE TYPE "business.EuropeanCEFLevel" AS ENUM ('A1','A2','...
You need 8.3 for this to work.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.