Re: How to get CURRENT_DATE in a pl/pgSQL function

Поиск
Список
Период
Сортировка
От Tim Landscheidt
Тема Re: How to get CURRENT_DATE in a pl/pgSQL function
Дата
Msg-id m3pr0si1gq.fsf@passepartout.tim-landscheidt.de
обсуждение исходный текст
Ответ на How to get CURRENT_DATE in a pl/pgSQL function  (Kenneth Marshall <ktm@rice.edu>)
Список 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 по дате отправления:

Предыдущее
От: silly sad
Дата:
Сообщение: Re: How to get CURRENT_DATE in a pl/pgSQL function
Следующее
От: Jasen Betts
Дата:
Сообщение: Re: How to get CURRENT_DATE in a pl/pgSQL function