Re: Problems with PLPGSQL - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Problems with PLPGSQL
Date
Msg-id 20031106142729.GA18854@wolff.to
Whole thread Raw
In response to Re: Problems with PLPGSQL  (Alex <alex@meerkatsoft.com>)
List pgsql-general
On Thu, Nov 06, 2003 at 18:17:52 +0900,
  Alex <alex@meerkatsoft.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.

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Problems with PLPGSQL
Next
From: Bruno Wolff III
Date:
Subject: Re: Sequences without blank holes