Re: [GENERAL] casting... adding integer to timestamp

[Mark Gibson]

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


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq