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