Re: Question about the enum type

On Feb 17, 2008, at 10:41 PM, Chris wrote:

> Chris wrote:
>>> I'm just toying around, so this isn't high priority. I'll probably
>>> change the name of the enum to fielding_position for clarity's sake
>>> anyway. But for my own education - what's so unique about the name
>>> 'position'?
>> It's a string manipulation function:
>> http://www.postgresql.org/docs/8.3/interactive/functions-string.html

If the issue were simply that it were a function name, than I would
have expected that attempting to create an enum type of 'abs' to also
result in a quoted type. That didn't happen, and I stated so in my
initial e-mail.

> Forgot to say, you can see a list of reserved words in the manual too:
>
> http://www.postgresql.org/docs/8.3/interactive/sql-keywords-
> appendix.html
>
> and it's reserved there too.

Yup. Saw that about 3 minutes after I sent the original question. I
sent a follow-up covering that. What I didn't state in that e-mail was
that I tried to create an enum type that was another name in the list
which was non-reserved (cannot be function or type). In that case, I
did see the automatic quoting behavior I saw with position.

Thanks for the prompt reply.

Tim Hart