Re: Sequenz mit Ausnahmen

[Andreas Kretschmer <akretschmer(at)spamfence(dot)net>]

Andreas Kretschmer <akretschmer(at)spamfence(dot)net> schrieb:
> Die Funktion in 'foo_seq.sql':
> create or replace function _foo_seq() returns trigger as $$
> begin
>         if currval('seq_foo') between 5 and 10 then
>                 perform setval('seq_foo', 10);
>         end if;
>         return NULL;
> end;
> $$ language plpgsql;

Nachtrag:

$$-Quoting geht erst ab 8.x, das mußt Du also anpassen. Ich hab grad
keine alte Version zur Hand, das zu probieren...


Andreas
-- 
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."    (unknow)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°