Re: Temporal Table Proposal

Hi Paul,

On Sat, Feb 23, 2019 at 2:16 AM Paul Jungwirth <pj@illuminatedcomputing.com>
wrote:

> On 2/22/19 11:31 AM, Euler Taveira wrote:
> > Em sex, 22 de fev de 2019 às 15:41, Ibrar Ahmed
> > <ibrar.ahmad@gmail.com> escreveu:
> >>
> >> While working on another PostgreSQL feature, I was thinking that we
> could use a temporal table in PostgreSQL. Some existing databases offer
> this. I searched for any discussion on the PostgreSQL mailing list, but
> could not find any. Maybe my search wasn’t accurate enough:  if anyone can
> point me to a discussion, that would be useful.
> >>
> >
> https://www.postgresql.org/message-id/CA%2BrenyUb%2BXHzsrPHHR6ELqguxaUPGhOPyVc7NW%2BkRsRpBZuUFQ%40mail.gmail.com
> >
> > This is the last one. I don't know why it wasn't in the January CF.
>
> Oh that's by me! :-)
>
> I didn't put it into the CF because I wanted to get some feedback on
> primary keys before I got too far into foreign keys, but someone
> recently advised me to starting adding to CFs anyway with "WIP" in the
> title, so I'll do that next time.
>
> Btw my own patch is very modest, and I'd love to see this other much
> more extensive patch get some attention:
>
>
> https://www.postgresql.org/message-id/flat/CAHO0eLYyvuqwF%3D2FsgDn1xOs_NOrFBu9Xh-Wq%2BaWfFy0y6%3DjWQ%40mail.gmail.com#4f7fbace3a2f2ce85fcc161cc3fdd273
>
> They were told to adjust where in the query pipeline they do their work,
> and the latest patch does that (as I understand it), but I don't think
> anyone has looked at it yet.
>
> Both of these patches use range types rather than SQL:2011 PERIODs, but
> I'd like to *also* support PERIODs (and accept ranges everywhere we
> accept PERIODs). Vik Fearing already has a patch to let you *declare*
> PERIODs:
>
> https://www.postgresql-archive.org/Periods-td6022563.html
>
> Actually using PERIODs in queries seems like a decent chunk of work
> though: basically it means making our grammar & processing accept
> PERIODs anywhere they currently accept columns. I'd love to hear some
> thoughts/suggestions around that. For example: a PERIOD is *similar* to
> a GENERATED column, so maybe the work being done there can/should
> influence how we implement them.
>
> I'm excited to be getting some momentum around temporal features though!
> I'm supposed to give a talk about them at PGCon in Ottawa this spring,
> so hopefully that will help too.
>
> Yours,
>
> --
> Paul              ~{:-)
> pj@illuminatedcomputing.com
>
> Great, to hear that you are working on that. Do you think I can help you
with this? I did some groundwork to make it possible. I can help in
coding/reviewing or even can take lead if you want to.

-- 
Ibrar Ahmed