Re: Problems with PLPGSQL - Mailing list pgsql-general

From Richard Huxton
Subject Re: Problems with PLPGSQL
Date
Msg-id 200311061108.09221.dev@archonet.com
Whole thread Raw
In response to Re: Problems with PLPGSQL  (Alex <alex@meerkatsoft.com>)
Responses Re: Problems with PLPGSQL  (Alex <alex@meerkatsoft.com>)
Re: Problems with PLPGSQL  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: INSERT and UPDATE of ALLBALLS/INFINITY dates and MOVE
Next
From: Martin Marques
Date:
Subject: Re: PostgreSQL v7.4 Release Candidate 1 compile errors