Richard Huxton <dev@archonet.com> writes:
> On Thursday 06 November 2003 10:00, Alex wrote:
>> as for the timestamp, both ways work fine, but the other problem still
>> exists. using a
>> ''60 Min'' works just fine, but WHERE job_end + ($1::text || '' Min'' )
> You probably want a cast:
> + ($1::text || '' min'')::interval
This is pretty much the hard way, though. A better idea is to use the
number-times-interval operator:
timestampvalue + $1 * '1 min'::interval;
Easier to write and faster.
regards, tom lane