LOOP and EXIT

Поиск
Список
Период
Сортировка
От Sebastian Kühner
Тема LOOP and EXIT
Дата
Msg-id 00c601c58709$fce8d560$6501a8c0@oper2
обсуждение исходный текст
Ответы Re: LOOP and EXIT  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Список pgsql-admin
Hello,

I'm new here in this group... and I hope that I find the solution for my
problem here.

I wrote a simple function which looks like this:

CREATE OR REPLACE FUNCTION watchdog() RETURNS TIME AS '
 DECLARE
  watchdog_control RECORD;
  help RECORD;
 BEGIN
  LOOP
   PERFORM * FROM watchdog_ctl;

   IF NOT FOUND THEN
    EXIT;
   END IF;

   PERFORM sleep(3);

  END LOOP;
  RETURN now();
 END;
' LANGUAGE plpgsql;

That means that I want to leave the loop if there isn't an entry in the
table watchdog_ctl. This works fine if the table is empty at the startup of
the function (select watchdog();). But if I empty the table watchdog_ctl
while the function is running it seems to be an endless loop. Hay anyone of
you an idea why??

Many thanks!

Sebastian



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

Предыдущее
От: Chris Hoover
Дата:
Сообщение: Anyone running PostgreSQL on Sun Solaris?
Следующее
От: prav maha
Дата:
Сообщение: ERROR: Bogus amopstrategy number 2439 for opclass 1989