Re: Problems with PLPGSQL

From: Richard Huxton <dev(at)archonet(dot)com>
To: Alex <alex(at)meerkatsoft(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Problems with PLPGSQL
Date: 2003-11-06 11:08:09
Message-ID: 200311061108.09221.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martin Marques 2003-11-06 11:24:46 Re: PostgreSQL v7.4 Release Candidate 1 compile errors
Previous Message Peter Eisentraut 2003-11-06 10:59:18 Re: INSERT and UPDATE of ALLBALLS/INFINITY dates and MOVE