Postgres Pro
Downloads
Home   >   mailing lists

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 m3d3wsn973.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>)
Responses Re: How to get CURRENT_DATE in a pl/pgSQL function  (Brian Modra <brian@zwartberg.com>)
List pgsql-sql
Tree view 
Kenneth Marshall <ktm@rice.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

pgsql-sql by date:

Previous
From: Alex Hunsaker
Date:
Subject: Re: plperlu user function.
Next
From: Brian Modra
Date:
Subject: Re: How to get CURRENT_DATE in a pl/pgSQL function