Re: [GENERAL] Plpgsql - Custom fields Postgres 9.5 - Mailing list pgsql-general

From David G. Johnston
Subject Re: [GENERAL] Plpgsql - Custom fields Postgres 9.5
Date
Msg-id CAKFQuwYCnDe5p2fsTPg8WDAox+feCFRdgREwb-yuzaQD_Ao=ZA@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] Plpgsql - Custom fields Postgres 9.5  (Patrick B <patrickbakerbr@gmail.com>)
Responses Re: [GENERAL] Plpgsql - Custom fields Postgres 9.5
List pgsql-general
On Wed, Dec 14, 2016 at 4:49 PM, Patrick B <patrickbakerbr@gmail.com> wrote:

ERROR:  function logextract(integer, integer) does not exist

LINE 1: select logextract(20160901,20161001);

So change the constants you are passing into your function to text (i.e., surrounding them with single quotes) so it matches the new function signature.

There exists an element of understanding the options you are being given and adapting if something basic like this is overlooked.

David J.

pgsql-general by date:

Previous
From: Patrick B
Date:
Subject: Re: [GENERAL] Plpgsql - Custom fields Postgres 9.5
Next
From: rob stone
Date:
Subject: Re: [GENERAL] Plpgsql - Custom fields Postgres 9.5