ALTER TYPE my_enum AS ENUM ADD ('label10')

From: Andreas Gaab <A(dot)Gaab(at)scanlab(dot)de>
To: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: ALTER TYPE my_enum AS ENUM ADD ('label10')
Date: 2010-03-22 14:33:48
Message-ID: 48DA836F3865C54B8FBF424A3B775AF6FDE72900@Exchange-Server.scanlab-intern.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi all,

I start working with enumerator types and I am wondering, if my enumerator can later be adjusted. E.g. if I would like to add another label.

Is it allowed just to add another entry to pg_enum? How is the enumerator then sorted (i.e. enum_last() )?

Is it possible to alter the labels of an enumerator later on? Can I edit pg_enum?

Thanks already,
Andreas Gaab

___________________________________________________________________________

SCANLAB AG
Dr. Andreas Simon Gaab
Entwicklung * R & D

Siemensstr. 2a * 82178 Puchheim * Germany
Tel. +49 (89) 800 746-513 * Fax +49 (89) 800 746-199
mailto:a(dot)gaab(at)scanlab(dot)de * www.scanlab.de<http://www.scanlab.de>

Amtsgericht München: HRB 124707 * USt-IdNr.: DE 129 456 351
Vorstand: Georg Hofner (Sprecher), Christian Huttenloher, Norbert Petschik
Aufsichtsrat (Vorsitz): Dr. Hans J. Langer
___________________________________________________________________________

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message A. Kretschmer 2010-03-22 15:05:15 Re: ALTER TYPE my_enum AS ENUM ADD ('label10')
Previous Message mahmoud ewiwi 2010-03-20 09:11:28 Stefanie Diedrich