Tom Dunstan wrote:
Tom Lane wrote:
While all this reasoning is perfectly OK on its own terms, it ignores
the precedents of SQL identifier handling. Maybe we should revisit the
question of whether the labels are identifiers.
Implying that they shouldn't be quoted like text (or should be
double-quoted if required)? Originally when discussing the patch I
thought that this was a good idea, but now I'm not so sure. How does
one set an enum value from e.g. a JDBC PreparedStatement in that
scenario?
Heh ... I read the statement the other way, i.e. maybe we should treat
them entirely as strings with no length limitation. The trouble is they
are half identifiers and half not right now. We certainly can't treat
them fully as identifiers unless I'm right off course - the ambiguities
would be horrendous.
cheers
andrew
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq