Re: [GENERAL] Plpgsql - Custom fields Postgres 9.5 - Mailing list pgsql-general

From Jeff Janes
Subject Re: [GENERAL] Plpgsql - Custom fields Postgres 9.5
Date
Msg-id CAMkU=1z==UrditQ75EGa6WrMrVMSOsOUDQ_TyZ9kOVzHzYD7kg@mail.gmail.com
Whole thread Raw
In response to [GENERAL] Plpgsql - Custom fields Postgres 9.5  (Patrick B <patrickbakerbr@gmail.com>)
List pgsql-general
On Wed, Dec 14, 2016 at 1:17 PM, Patrick B <patrickbakerbr@gmail.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

pgsql-general by date:

Previous
From: Richard Brosnahan
Date:
Subject: [GENERAL] PostgreSQL mirroring from RPM install to Source install
Next
From: Jan de Visser
Date:
Subject: Re: [GENERAL] pg_dump and quoted identifiers