- 01
- 02
- 03
- 04
- 05
- 06
- 07
- 08
- 09
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
order_columns = u'id_np asc, id_street asc, '\
+ column + ' ' + order\
+ u"cast("\
u"NULLIF(" \
u"regexp_replace(" \
u"regexp_replace(" \
u"regexp_replace(" \
u"regexp_replace(" \
u"regexp_replace(" \
u"regexp_replace(" + column + u", '[ёА-яа-яA-Za-z\s]+', '')," \
u" '[/-\\\]+', '', 'g'), " \
u"'[-]+', '', 'g'), " \
u"'[А-яа-я\s,]+', '', 'g'), " \
u"'[А-яа-я)(\s]+', ''), " \
u"'', '0'), " \
u"'0') " \
u"AS FLOAT) "
j123123 16.03.2017 09:47 # +2
gost 16.03.2017 14:29 # 0