From: | Dwayne Miller <dwayne-miller(at)home(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Time as keyword |
Date: | 2002-01-09 14:52:43 |
Message-ID: | 3C3C593B.8000500@home.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I tried to create table foo (t time, time time); and received an error
something like
'Error parsing near time'
I'm on 7.2.b2
I'll upgrade and try again.
Tom Lane wrote:
>Dwayne Miller <dwayne-miller(at)home(dot)com> writes:
>
>>Did time become a keyword in 7.2? 7.1.3 allowed it as a column name...
>>7.2 rejects it.
>>
>
>It's always been a keyword, but it is "more reserved" than it used to
>be. See
>
>http://developer.postgresql.org/docs/postgres/sql-keywords-appendix.html
>
>However, according to that list TIME is still allowed as a column name,
>and indeed I get:
>
>regression=# create table foo (f1 time, time time);
>CREATE
>
>So I'm not sure what you did.
>
> regards, tom lane
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-01-09 15:14:05 | Re: again on index usage |
Previous Message | Doug McNaught | 2002-01-09 13:42:00 | Re: Some architectures need "signed char" declarations |