Thanks Tom and Richard for the tip on date_trunc. Is it possible in an
sql select statement to create an iterator?
For instance
select myItFunc(1,10);
would give 1,2,3,4,5,6,7,8,9,10
I'm a bit embarrassed that I don't know how to do this. My
understanding of sql functions is that not being object oriented, they
don't store state.
The reason I'm asking is that if I wanted to to use date_trunc, I think
I would need some sort of iterator to get multiple rows in one statement.
What I'm looking for is:
Employee Week Amount
John 1/1 100
Mary 1/1 0
Edward 1/2 100
etc
I'd also like to return zero or null values when the data doesn't
exist. Wouldn't I need an iterator to do that?
Thanks,
Omar
Tom Lane wrote:
> Omar Eljumaily <omar2@omnicode.com> writes:
>
>> I want to tabulate time data on a weekly basis, but my data is entered
>> on a daily basis.
>>
>
> Something involving GROUP BY date_trunc('week', _date) might work for
> you, if your definition of week boundaries matches date_trunc's.
> If not, you could probably make a custom function that breaks at the
> boundaries you want.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org/
>