Re: Plpgsql - Custom fields Postgres 9.5

On Wed, Dec 14, 2016 at 1:17 PM, Patrick B <patrickbakerbr(at)gmail(dot)com> wrote:

>
>
> 2. To call the function, I have to login to postgres and then run: select
> logextract(201612015, 201612015);
> How can I do it on cron? because the dates will be different every time.
>

PostgreSQL already knows what date today is. Why does cron have to tell
it? Just do 'select logextract()' and let Postgresql compute the dates for
itself.

Cheers,

Jeff