On Tue, 21 Jun 2005, Bruce Momjian wrote:

> Pavel Stehule wrote:
> > Hello, 
> > 
> > I sended version with only LEAST and GREATEST
> > http://archives.postgresql.org/pgsql-patches/2005-06/msg00185.php
> 
> OK, did you remove DECODE for a reason?
> 
  o simplify patch
  o decode can be added in future if will be requirement

> > this patch contains diff files for NEXT_DAY and LAST_DAY function too, 
> > which I think are generally usefull.
> > 
> > There is duplicity with CASE. 
> 
> I didn't think we needed NEXT_DAY and LAST_DAY because we have +
> interval like + '1 day'.  We decided that, right?
> 
next_day not equal date + 1day, but like next monday, ... look to doc.
  next_day (date, varchar) -- varchar = sunday|monday|...

last_day is very often used function. Really. I can substitute

  create or replace function last_day(date) returns date $$
    select date_trunc('month', $1 + interval '1month') - 1;
  $$ language sql;

but I think can be usefull (for first day we have date_drunc, for 
last_date nothing)

regards
Pavel


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to