Re: casting... adding integer to timestamp

[Frank Finner <postgresql(at)finner(dot)de>]

On Sat, 24 Jun 2006 23:23:57 -0600 Mark Gibson <mark(at)gibsonsoftware(dot)com> thought long, then sat down and 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"
> 

SELECT play_length - play_seconds... 
should do the trick, if play_sconds is of type interval. Otherwise you must explicitly cast it like 
SELECT play_length - play_seconds::interval...

Regards,
-- 
Frank Finner

Invenius - Lösungen mit Linux
Köpfchenstraße 36
57072 Siegen
Telefon: 0271 231 8606    Mail: frank(dot)finner(at)invenius(dot)de
Telefax: 0271 231 8608    Web:  http://www.invenius.de
Key fingerprint = 90DF FF40 582E 6D6B BADF  6E6A A74E 67E4 E788 2651

Attachment: pgpM0G4cmrfrS.pgp
Description: PGP signature