On Wed, 2016-12-14 at 17:00 -0700, David G. Johnston wrote: > On Wed, Dec 14, 2016 at 4:49 PM, Patrick B <patrickbakerbr@xxxxxxxxx> > 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. 1) Have you run a \df+ and made sure the function has been created correctly? 2) In your first post there is a single apostrophe after the execute instruction. Can't see the closing apostrophe but then my eyesight is not the best. 3) I've always found it easier to TO_CHAR a date column when using it for comparison purposes. HTH. Rob -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
