Re: casting... adding integer to timestamp

[Alex Pavlovic <alex(dot)pavlovic(at)taskforce-1(dot)com>]

Yet another way, this time being more explicit.

SELECT play_length - play_seconds * '1 second'::interval


Cheers.

On Saturday 24 June 2006 22:23, Mark Gibson wrote:
> If play_length is a timestamp, I can do this:
>
> SELECT  play_length - INTERVAL '13 seconds' ...
>
> But what if play_seconds is a column?
>
> SELECT  play_length - INTERVAL 'play_seconds seconds' ...
>
> This doesn't work.
>
> ERROR:  invalid input syntax for type interval: "play_seconds seconds"
>
> Can anyone help?
>
> Thanks,
> Mark
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster