Re: How to get CURRENT_DATE in a pl/pgSQL function - Mailing list pgsql-sql

From Tim Landscheidt
Subject Re: How to get CURRENT_DATE in a pl/pgSQL function
Date
Msg-id m3pr0si1gq.fsf@passepartout.tim-landscheidt.de
Whole thread Raw
In response to How to get CURRENT_DATE in a pl/pgSQL function  (Kenneth Marshall <ktm@rice.edu>)
List pgsql-sql
Brian Modra <brian@zwartberg.com> wrote:

>>> It works using 'now' and I assume that since curtime is
>>> of type DATE that the assignment casts the return automatically
>>> to type DATE. Thank you for the ideas.
>>> [...]

>> What's wrong with Pavel's correct and to-the-point answer?

> No need actually to cast... just use current_date without the quotes.
> Its not a string.

Where did Pavel suggest to cast or use a string?

Tim



pgsql-sql by date:

Previous
From: silly sad
Date:
Subject: Re: How to get CURRENT_DATE in a pl/pgSQL function
Next
From: Jasen Betts
Date:
Subject: Re: How to get CURRENT_DATE in a pl/pgSQL function