March 14, 2011 – Dan Langille's Other Diary

Speakers and travel

1 Comment / Open Source, Pentabarf, PostgreSQL / By Dan Langille / March 14, 2011

The following query pulls back the speakers and their travel: SELECT distinct S.name, S.email, CP.conference_person_id, arrival_from, arrival_to, arrival_number, arrival_date, arrival_time, departure_from, departure_to, departure_number, departure_date, departure_time FROM event E, view_event_person P, view_mail_all_speaker S, conference_person CP, conference_person_travel CPT WHERE E.event_id = P.event_id AND P.person_id = S.person_id AND E.conference_id = 7 AND CP.conference_id = E.conference_id AND E.event_state = […]

Speakers and travel Read More »

PGCon – keynote… made your travel bookings yet?

Although PGCon 2011 is just 9 weeks away, that time will fly past. People will start gathering in Ottawa early in the week for the two days of tutorials followed by two days of talks. PGCon is also a social event, so there will be many opportunities to mingle and meet other members of your