Re: Problems with PLPGSQL

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Alex <alex(at)meerkatsoft(dot)com>
Cc: jasongodden(at)optushome(dot)com(dot)au, pgsql-general(at)postgresql(dot)org
Subject: Re: Problems with PLPGSQL
Date: 2003-11-06 14:27:29
Message-ID: 20031106142729.GA18854@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Nov 06, 2003 at 18:17:52 +0900,
Alex <alex(at)meerkatsoft(dot)com> wrote:
> Hi Jason,
> thanks, for the reply. Tried that one but still getting an error
>
> Unable to identify an operator + for types timestamp without time zone
> and text ....

You probably need an explicit cast from text to interval. An untyped
(unknown) string gets handled differently than one of type text.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2003-11-06 14:33:04 Re: Sequences without blank holes
Previous Message btober 2003-11-06 13:52:35 on connect trigger