i want to create a script which could activate itself when a condition in a table is met. whell my problem is that i didn;t found a way to create a such script, another ideea would be that to create a function which check a table each second and if a condition is met to run another function.
the last option is acceptabe thus the first one is ideeal
the real problem is that for second solution (to run a script each second) i found such thing only in oracle pl/sql(dbms sheduler), so i'm asking : is there something similar for pl/pgsql to do that?
of, if you have a solution for first case (the autocheck) please let me know
thanck you for your help but i don't think that will help me:
in pgadmin i didn't see such thing as interfal of one second, he is mostly like a cron job, with minimum 1 minute interval
secondly trigers are not a option since this this action will start when a value in a table will be equal with system time, not on a update/delete etc...
anyway here is oracle's dbms_scheduler they can run a scripteach second, i hope there is a similar thing in postgres to do that