Skip site navigation (1) Skip section navigation (2)

dynamic interval in plpgsql

From: Thilo Hille <thilo(at)resourcery(dot)de>
To: pgsql-novice(at)postgresql(dot)org
Subject: dynamic interval in plpgsql
Date: 2004-03-29 10:51:11
Message-ID: 4067FF9F.20706@resourcery.de (view raw or flat)
Thread:
Lists: pgsql-novice
hi,
i work on a stored procedure which does some timespecific calculations 
in plpgsql.
in a loop i want  to increase a timestamp by a changing interval. but i 
found no way to assign a variable to INTERVAL .
finally i used plpython for the function but i still wonder if it could 
be done with plpgsql?

regards thilo

Responses

pgsql-novice by date

Next:From: Alexandre RicciardiDate: 2004-03-29 11:09:39
Subject: problem on psql command
Previous:From: Oliver FrommeDate: 2004-03-29 08:00:05
Subject: Re: Images in Database

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group