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