> > 1. Why when I run the function manually I get this error? >> >> select logextract(201612015, 201612015); >> >> ERROR: operator does not exist: timestamp without time zone >= >> integer >> >> LINE 13: BETWEEN >> > > The answer is above. Look at your original query at the top of the post. > > >> >> I presume this is wrong: _CREATE or REPLACE FUNCTION >> logextract(date_start integer, date_end integer) _- But what should I >> use instead? >> >> >> <adrian.kla...@aklaver.com> >> > You mean the error would be: select logextract(201612015, 201612015);
When it was supposed to be: select logextract(201611015, 201612015);??? This is not the cause, because it was a mistake when I typed the email. Even doing: select logextract(20161115,20161215); I get same error.
