Re: Problems with PLPGSQL

On Thursday 06 November 2003 10:00, Alex wrote:
> Hi Richard,
> 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

--
  Richard Huxton
  Archonet Ltd