BUG #5553: Repeating the keyword DECLARE in the CREATE FUNCTION statement
The following bug has been logged online:
Bug reference: 5553
Logged by: Sergey
Email address: sklo@mail.ur.ru
PostgreSQL version: 9 beta 2
Operating system: Windows XP
Description: Repeating the keyword DECLARE in the CREATE FUNCTION
statement
Details:
Is it a normal behavior of the parser:
CREATE OR REPLACE FUNCTION row_ret13(b_in IN BOOLEAN = true or false,
INTEGER DEFAULT 0 )
RETURNS BOOLEAN
AS
$$
DECLARE
DECLARE
DECLARE a integer DEFAULT 32;
DECLARE
DECLARE
DECLARE
DECLARE
DECLARE b integer DEFAULT 32;
DECLARE
DECLARE
BEGIN
RETURN FALSE OR b_in;
END;
$$
LANGUAGE PLPGSQL;
- Parsed.
select row_ret13();
======
t
Thanks,
Sergey.
"Sergey" <sklo@mail.ur.ru> writes:
Description: Repeating the keyword DECLARE in the CREATE FUNCTION
statement
Is it a normal behavior of the parser:
Yes. This isn't a bug, you've just written a bunch of empty DECLARE
sections.
regards, tom lane