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

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'

Hope this helps.

Michael Glaesemann
grzm seespotcode net