Re: [GENERAL] Plpgsql - Custom fields Postgres 9.5
| От | Patrick B |
|---|---|
| Тема | Re: [GENERAL] Plpgsql - Custom fields Postgres 9.5 |
| Дата | |
| Msg-id | CAJNY3iuDzuKYgeK3zbuALH2vD2HRdWyUbjQw9U9B3PfPPxJV4g@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: [GENERAL] Plpgsql - Custom fields Postgres 9.5 (Adrian Klaver <adrian.klaver@aklaver.com>) |
| Ответы |
Re: [GENERAL] Plpgsql - Custom fields Postgres 9.5
|
| Список | pgsql-general |
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);
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.
В списке pgsql-general по дате отправления: