Re: [SQL] Generating Rows from a date and a duration

2010-09-08 Thread Joe Conway
On 09/08/2010 08:24 AM, Tim Schumacher wrote: >>> I'm kinda stuck situation, I have a timestamp which resambles a >>> startdate and a duration in days and I want to bloat this, so I have a >>> row for every day beginning from the startdate. I have created an >>> example bellow, maybe I'm doing it o

Re: [SQL] Generating Rows from a date and a duration

2010-09-08 Thread Tim Schumacher
Hi Brian, Hi List, At Sat, 4 Sep 2010 09:20:53 -0400, Brian Sherwood wrote: > On Fri, Sep 3, 2010 at 5:40 AM, Tim Schumacher < > tim.daniel.schumac...@gmail.com> wrote: > > > I'm kinda stuck situation, I have a timestamp which resambles a > > startdate and a duration in days and I want to bloat

[SQL] Table returning functions

2010-09-08 Thread Jann Röder
Hi, I have a question which does not seem to be covered in the documentation: I have a function f(i) that returns a table with three columns (a, b, c). In the documentation (http://www.postgresql.org/docs/8.4/interactive/xfunc-sql.html#XFUNC-SQL-FUNCTIONS-RETURNING-SET) it says that (even though d