Generating Table / array on the fly in postgresql function

Posted by bensiu on Stack Overflow See other posts from Stack Overflow or by bensiu
Published on 2010-06-16T23:38:02Z Indexed on 2010/06/17 0:22 UTC
Read the original article Hit count: 609

I need to create postgresql function

CREATE FUNCTION date_ranges (_start date, end date) 
  RETURNING TABLE(day_in_range date) AS...

if I call date_ranges('2010-06-01', 2010-06-05') I should receive

2010-06-01
2010-06-02
2010-06-03
2010-06-04
2010-06-05

Any Ideas how to do it?

© Stack Overflow or respective owner

Related posts about sql

Related posts about postgresql