Re: Function to offset current timestamp

Dan Harris wrote:
> I'm trying to write a function that can do a select on an integer value
> from a table and subtract that value from current_timestamp.
>
> Let's say I have a table called users and a field called tz_offset..
>
> I want my function to do something like :
>
> select current_timestamp - '( select tz_offset from users where userid =
> ? ) hours'::interval
>
> Obviously this syntax is incorrect, but I'm not quite sure how to do the
> subquery and make the integer result of it part of the quoted interval
> expression.
>
> Any tips?
>
> Thx
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>               http://archives.postgresql.org

ok, sorry to reply to my own message, but I figured out a way:

select current_timestamp - ( select tz_offset from users where userid = ? ) * '1
hour'::interval;