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

From: Tim Landscheidt <tim(at)tim-landscheidt(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: How to get CURRENT_DATE in a pl/pgSQL function
Date: 2010-05-18 22:20:32
Message-ID: m3d3wsn973.fsf@passepartout.tim-landscheidt.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Kenneth Marshall <ktm(at)rice(dot)edu> 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?

Tim

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Brian Modra 2010-05-19 03:48:33 Re: How to get CURRENT_DATE in a pl/pgSQL function
Previous Message Alex Hunsaker 2010-05-18 21:36:27 Re: plperlu user function.