bug in PLPGSQL
От | Andriy I Pilipenko |
---|---|
Тема | bug in PLPGSQL |
Дата | |
Msg-id | Pine.BSF.4.21.0103281253040.89943-100000@bamby.marka.net.ua обсуждение исходный текст |
Список | pgsql-bugs |
Your name : Andriy I Pilipenko Your email address : bamby@marka.net.ua System Configuration --------------------- Architecture (example: Intel Pentium) : Intel Pentium Operating System (example: Linux 2.0.26 ELF) : FreeBSD-4.2-STABLE PostgreSQL version (example: PostgreSQL-7.0): PostgreSQL-7.0.3 Compiler used (example: gcc 2.8.0) : gcc version 2.95.2 19991024 (release) Please enter a FULL description of your problem: ------------------------------------------------ There is bug in PLPGSQL. If one of the parameters to plpgsql function is null, other parameters becomes null too. Please describe a way to repeat the problem. Please try to provide a concise reproducible example, if at all possible: ---------------------------------------------------------------------- First create function like this: CREATE FUNCTION f(varchar, varchar) RETURNS varchar AS ' begin return ''first arg is: '' || $1; end; ' LANGUAGE 'plpgsql'; Then run query "SELECT f('some text', NULL)" and you will receive null value. If you know how this problem might be fixed, list the solution below: ---------------------------------------------------------------------
В списке pgsql-bugs по дате отправления: