Re: temporal version of generate_series() - Mailing list pgsql-patches

From H.Harada
Subject Re: temporal version of generate_series()
Date
Msg-id e08cc0400805010036j3101d4c8re559a77027665928@mail.gmail.com
Whole thread Raw
In response to Re: temporal version of generate_series()  ("Pavel Stehule" <pavel.stehule@gmail.com>)
Responses Re: temporal version of generate_series()  (H.Harada <umi.tanuki@gmail.com>)
List pgsql-patches
2008/5/1 Pavel Stehule <pavel.stehule@gmail.com>:
> Hello
>
>  why you don't use polymorphic types?
Ah, good idea. I didn't think we could fix the third argument to
"interval" but "anyelement".
For a temporal version, it's reasonable.

Also, the name "generate_time_series" is better than before?

Hitoshi Harada


2008/5/1 Pavel Stehule <pavel.stehule@gmail.com>:
> Hello
>
>  why you don't use polymorphic types?
>
>  like:
>
>  create or replace function generate_time_series(anyelement,
>  anyelement, interval, OUT result anyelement)
>  returns setof anyelement as $$
>  begin
>   result := $1;
>   while (result <= $2) loop
>     return next;
>     result := result + $3;
>   end loop;
>   return;
>  end;
>  $$ language plpgsql;
>
>  Regards
>  Pavel Stehule
>
>
>
>  2008/5/1 H. Harada <umi.tanuki@gmail.com>:
>
>
> > Here's the sync and updated patch.
>  > It contains "strict" in catalog as well.
>  >
>  > Hitoshi Harada
>  >
>  > 2008/4/24 H. Harada <umi.tanuki@gmail.com>:
>  >> 2008/4/23 Alvaro Herrera <alvherre@commandprompt.com>:
>  >>
>  >> > H.Harada escribió:
>  >>  >
>  >>  >
>  >>  >  > # This is my first time to send a patch. If I did something wrong, I
>  >>  >  > appreciate your pointing me out.
>  >>  >
>  >>  >  Brace positioning is off w.r.t. our conventions -- please fix that and
>  >>  >  resubmit.
>  >>
>  >>  Here's updated version. Thanks for your advice.
>  >>
>  >>  Hitoshi Harada
>  >>
>  >>  2008/4/23 Alvaro Herrera <alvherre@commandprompt.com>:
>  >>
>  >>
>  >> > H.Harada escribió:
>  >>  >
>  >>  >
>  >>  >  > # This is my first time to send a patch. If I did something wrong, I
>  >>  >  > appreciate your pointing me out.
>  >>  >
>  >>  >  Brace positioning is off w.r.t. our conventions -- please fix that and
>  >>  >  resubmit.
>  >>  >
>  >>  >  I have added this patch to the May commitfest.
>  >>  >
>  >>  >  --
>  >>  >  Alvaro Herrera                                http://www.CommandPrompt.com/
>  >>  >  The PostgreSQL Company - Command Prompt, Inc.
>  >>  >
>  >>
>  >
>  >
>  > --
>  > Sent via pgsql-patches mailing list (pgsql-patches@postgresql.org)
>  > To make changes to your subscription:
>  > http://www.postgresql.org/mailpref/pgsql-patches
>  >
>  >
>

pgsql-patches by date:

Previous
From: "Pavel Stehule"
Date:
Subject: Re: temporal version of generate_series()
Next
From: "Pavel Stehule"
Date:
Subject: Re: plpgsql CASE statement - last version