Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- update cloudfront_log
- set landing_page_id = landing_page.id
- from landing_page
- where cloudfront_log.log->>'landing-page' = landing_page.landing_page
- and cloudfront_log.date_time >= '2017-01-05' -- %(date_time)s
- and cloudfront_log.date_time < cast('2017-01-05' as timestamp with time zone) + interval '1 days' -- cast(%(date_time)s as timestamp with time zone) + interval '1 weeks'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement