Re: Examples of accessing postgresql with scripts? - Mailing list pgsql-novice

Duh.  Thanks
Tom

On 31 May 2003 at 13:10, Tom Lane wrote:

> hodges@xprt.net writes:
> > This works for me:
> > a=`eval date`  # now $a is current date/time
> > psql tom -c "SELECT * FROM firesides where date > '$a'"
>
> > Now how to set $a to 3 days in the future?
>
> I dunno how you would do that on the shell-script side, but it's easy to
> do the date arithmetic on the SQL side instead:
>
> psql tom -c "SELECT * FROM firesides where date > (current_date + 3)"
>
>             regards, tom lane
>