Psst.. new poll here.
Psst.. new forums here.
Microsoft is blocking us again (TY IP Reputation!) so just use oauth login instead. :)
Paste
Pasted as SQL by mikhail ( 15 years ago )
[root@webjail /home/r12]# date
Tue Feb 15 14:16:15 MSK 2011
[root@webjail /home/r12]# psql meganet pgsql
psql (8.4.5)
Type "help" for help.
meganet=# select * from billing.schedule_rules;
rule_id | entry_id | weekday_from | weekday_to | monthday_from | monthday_to | min_to | hour_to | hour_from | min_from | month | year
---------+----------+--------------+------------+---------------+-------------+--------+---------+-----------+----------+-------+------
17 | 85 | 3 | 3 | 0 | 0 | 0 | 16 | 10 | 30 | |
38 | 97 | 0 | 0 | 18 | 22 | 20 | 17 | 13 | 10 | 11 | 2012
39 | 97 | 1 | 6 | 0 | 0 | 40 | 19 | 14 | 30 | 0 | 2011
41 | 98 | 0 | 0 | 19 | 19 | 30 | 18 | 12 | 20 | 3 | 2012
40 | 98 | 1 | 4 | 0 | 0 | 0 | 23 | 12 | 10 | 0 | 0
42 | 12 | 1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | |
43 | 13 | 0 | 0 | 0 | 0 | 50 | 0 | 0 | 30 | |
(7 rows)
meganet=# SELECT billing.check_calendar(ARRAY[12,13],now());
check_calendar
----------------
13
(1 row)
meganet=#
Revise this Paste