NULL as an argument in plpgsql functions

Поиск
Список
Период
Сортировка
От Oleg Bartunov
Тема NULL as an argument in plpgsql functions
Дата
Msg-id Pine.GSO.3.96.SK.990927215550.8336p-100000@ra
обсуждение исходный текст
Ответы Re: [HACKERS] NULL as an argument in plpgsql functions  (Bruce Momjian <maillist@candle.pha.pa.us>)
Re: [HACKERS] NULL as an argument in plpgsql functions  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hi,

this select produces error message:
test=> select test2(NULL);
ERROR:  typeidTypeRelid: Invalid type - oid = 0

test2:
CREATE FUNCTION test2 (int4) RETURNS int4 AS '
Declare
    keyval      Alias For $1;
    cnt         int4;
Begin
  Update hits set count = count +1  where msg_id = keyval;
  return cnt;
End;
' LANGUAGE 'plpgsql';

When I do manually update
Update hits set count = count +1  where msg_id = NULL;
it works fine. What's the problem ?

    Regards,

        Oleg


test=> \d hits
Table    = hits
+----------------------------------+----------------------------------+-------+
|              Field               |              Type                | Length|
+----------------------------------+----------------------------------+-------+
| msg_id                           | int4                             |     4 |
| count                            | int4                             |     4 |
+----------------------------------+----------------------------------+-------+
test=> select version();
version
------------------------------------------------------------------
PostgreSQL 6.5.2 on i586-pc-linux-gnulibc1, compiled by gcc 2.95.1
(1 row)

_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] pg_upgrade may be mortally wounded
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] another DECIMAL problem