2010/3/21 Bruce Momjian <bruce@momjian.us>:
> Hitoshi Harada wrote:
>> 2010/3/20 Bruce Momjian <bruce@momjian.us>:
>> > I have completed the 9.0 release notes:
>> >
>> > ? ? ? ?http://developer.postgresql.org/pgdocs/postgres/release-9-0.html
>> >
>>
>> I wonder if we need note a minor compatibility from extending window
>> function's frame.
>>
>> - Change BETWEEN from TYPE_FUNC_NAME_KEYWORD from COL_NAME_KEYWORD
>
> I see. The change appears to be from "can be function or type name" to
> "cannot be function or type name", according to
> misc.c::pg_get_keywords().
>
> What error will they see if they do use an invalid name? Will it be
> clear that they just need to rename it?
No, it's only parser error as other syntactic changes.
# 9.0
regression=# create or replace function between(i int) returns int as
$$ select $1 + $1 $$ language sql;
ERROR: syntax error at or near "("
LINE 1: create or replace function between(i int) returns int as $$ ...
whereas 8.4 can create it successfully.
This is still ok, as well as 8.4.
regression=# select 1 as between;between
--------- 1
(1 row)
Regards,
--
Hitoshi Harada