Re: Plpgsql - Custom fields Postgres 9.5

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Patrick B <patrickbakerbr(at)gmail(dot)com>
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Plpgsql - Custom fields Postgres 9.5
Date: 2016-12-15 00:00:23
Message-ID: CAKFQuwYCnDe5p2fsTPg8WDAox+feCFRdgREwb-yuzaQD_Ao=ZA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Dec 14, 2016 at 4:49 PM, Patrick B <patrickbakerbr(at)gmail(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message rob stone 2016-12-15 00:12:46 Re: Plpgsql - Custom fields Postgres 9.5
Previous Message Patrick B 2016-12-14 23:49:52 Re: Plpgsql - Custom fields Postgres 9.5