Re: casting... adding integer to timestamp - Mailing list pgsql-general

Michael Glaesemann wrote:
>
> On Jun 25, 2006, at 14:23 , Mark Gibson wrote:
>
>> SELECT  play_length - INTERVAL 'play_seconds seconds' ...
>
> The column isn't interpolated into the string. Try
>
> SELECT play_length - play_seconds * INTERVAL '1 second'
>


That worked great!  Thanks!

Mark