How do I schedule an update query in PostgreSQL for Windows? -


is possible create sort of function or trigger in postgresql update columns field in regards time?

for instance today want field equal 1, in 10 hours want equal 0.

is possible?

if value function of time can calculated @ query time. 0 or 1:

select (extract(hour current_time) >= 12)::int * 1;  ?column?  ----------         0 

or added view:

create view v select *, (extract(hour current_time) >= 12)::int * 1 t; 

Comments

Popular posts from this blog

blackberry 10 - how to add multiple markers on the google map just by url? -

php - guestbook returning database data to flash -

delphi - Dynamic file type icon -