Skip to content

Instantly share code, notes, and snippets.

@kelvinewilliams

kelvinewilliams/gist:e0b69e3514f4040f2cf9

Created December 7, 2015 19:34
Show Gist options
  • Save kelvinewilliams/e0b69e3514f4040f2cf9 to your computer and use it in GitHub Desktop.
Save kelvinewilliams/e0b69e3514f4040f2cf9 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
derecho=# select * from lcr.rates where lrn_prefix @> '1404543' and sdc_penalty = false order by interstate;
carrier_id | lrn_prefix | interstate | intrastate | effective_date | expiration_date | min_inc | add_inc | sdc_penalty | permanent
------------+------------+--------------+--------------+-------------------------------+-----------------+---------+---------+-------------+-----------
82638 | 1404543 | 0.0018700000 | 0.0018700000 | 2015-10-29 00:00:00+00 | | 6 | 6 | f | f
26663 | 1404543 | 0.0021000000 | 0.0021000000 | 2015-12-07 18:48:36.199341+00 | | 6 | 6 | f | f
47565 | 1404543 | 0.0022000000 | 0.0019000000 | 2015-11-13 00:00:01+00 | | 6 | 6 | f | f
78272 | 1404543 | 0.0023000000 | 0.0020000000 | 2015-10-16 19:17:50.585582+00 | | 6 | 6 | f | f
76263 | 1404543 | 0.0023600000 | 0.0023600000 | 2015-11-14 18:00:00+00 | | 6 | 6 | f | f
78249 | 1404543 | 0.0023800000 | 0.0022830000 | 2015-10-16 20:39:36.510631+00 | | 6 | 6 | f | f
25228 | 1404543 | 0.0028700000 | 0.0028700000 | 2015-10-14 00:00:01+00 | | 6 | 6 | f | f
(7 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment