Search Postgresql Archives

Re: Plpgsql - Custom fields Postgres 9.5

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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?




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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux