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 = ? )
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.
pgsql-admin by date
|Next:||From: Dan Harris||Date: 2007-06-01 17:46:58|
|Subject: Re: Function to offset current timestamp|
|Previous:||From: Hyatt, Gordon||Date: 2007-06-01 14:38:17|
|Subject: Failed install of PostgreSQL v8.2.4 - initdb fails with Access is denied|