Re: casting... adding integer to timestamp

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