BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//pretalx//pretalx.seagl.org//2024//speaker//G89SKM
BEGIN:VTIMEZONE
TZID:PST
BEGIN:STANDARD
DTSTART:20001029T030000
RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=10;UNTIL=20061029T100000Z
TZNAME:PST
TZOFFSETFROM:-0700
TZOFFSETTO:-0800
END:STANDARD
BEGIN:STANDARD
DTSTART:20071104T030000
RRULE:FREQ=YEARLY;BYDAY=1SU;BYMONTH=11
TZNAME:PST
TZOFFSETFROM:-0700
TZOFFSETTO:-0800
END:STANDARD
BEGIN:DAYLIGHT
DTSTART:20000402T030000
RRULE:FREQ=YEARLY;BYDAY=1SU;BYMONTH=4;UNTIL=20060402T110000Z
TZNAME:PDT
TZOFFSETFROM:-0800
TZOFFSETTO:-0700
END:DAYLIGHT
BEGIN:DAYLIGHT
DTSTART:20070311T030000
RRULE:FREQ=YEARLY;BYDAY=2SU;BYMONTH=3
TZNAME:PDT
TZOFFSETFROM:-0800
TZOFFSETTO:-0700
END:DAYLIGHT
END:VTIMEZONE
BEGIN:VEVENT
UID:pretalx-2024-9EWZJV@pretalx.seagl.org
DTSTART;TZID=PST:20241108T103000
DTEND;TZID=PST:20241108T112000
DESCRIPTION:Temporal databases let you record history: either a history of 
 the database (what the table used to say)\, a history of the thing itself 
 (what it used to be)\, or both at once.\n\nThis talk will cover temporal p
 rimary keys\, foreign keys\, updates\, deletes\, and joins: what they are\
 ,  how to perform them in SQL:2011 (and coming soon in Postgres!)\, and ho
 w to implement operations not yet covered by the standard\, like outer joi
 ns\, semijoins\, and antijoins.\n\nI'll discuss my work adding application
 -time to Postgres\, which was briefly part of v17 and will hopefully be co
 mplete for v18.
DTSTAMP:20260610T114901Z
LOCATION:340
SUMMARY:Temporal Data: Theory and Postgres - Paul A. Jungwirth
URL:https://pretalx.seagl.org/2024/talk/9EWZJV/
END:VEVENT
END:VCALENDAR