Re: Strange DOMAIN behavior

On 09.07.2015 19:50, David G. Johnston wrote:
> On Thu, Jul 9, 2015 at 12:42 PM, Alex Ignatov
> <a(dot)ignatov(at)postgrespro(dot)ru <mailto:a(dot)ignatov(at)postgrespro(dot)ru>>wrote:
>
> DROP FUNCTION lexema_test( );
> CREATE OR REPLACE FUNCTION lexema_test()
> RETURNS VOID AS $body$
> DECLARE
> lex lexema :=new_lexema();
> BEGIN
> END;
> $body$
> LANGUAGE PLPGSQL
> SECURITY DEFINER;
>
> Then I got:
> ERROR: default value for row or record variable is not supported
> LINE 17: lex lexema :=new_lexema();
>
>
>
>
> ​Undocumented limitation :(
>
> While slightly more verbose you simply need to:
>
> DECLARE lex lexema;
> BEGIN
> lex := new_lexema();
> [...]
>
> David J.
>
Thats sad =(. But it is not so gracefully to initialize composite type
in the begin block as it would be in declare block %).
Thank you for yours answers!

--
Alex Ignatov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus