@@ -103,7 +103,7 @@ BEGIN
103103 LOOP
104104 FOR d IN 1..2 LOOP
105105 INSERT INTO root_dict (root_id, start_date, num, main, dict_code, dict_name, edit_num, edit_date, sign) VALUES
106- (r.r,now() , 'num_' || d, (d % 2) + 1, 'code_' || d, 'name_' || d, NULL, NULL, '2014');
106+ (r.r,'2010-10-10'::date , 'num_' || d, (d % 2) + 1, 'code_' || d, 'name_' || d, NULL, NULL, '2014');
107107 END LOOP;
108108 END LOOP;
109109END
@@ -136,51 +136,51 @@ WHERE root_id = $1;
136136EXECUTE getbyroot(2);
137137 id | root_id | start_date | num | main | edit_num | edit_date | dict_id
138138----+---------+------------+-------+------+----------+-----------+---------
139- 3 | 2 |09-12-2018 | num_1 | 2 | | | 3
140- 4 | 2 |09-12-2018 | num_2 | 1 | | | 3
139+ 3 | 2 |10-10-2010 | num_1 | 2 | | | 3
140+ 4 | 2 |10-10-2010 | num_2 | 1 | | | 3
141141(2 rows)
142142
143143EXECUTE getbyroot(2);
144144 id | root_id | start_date | num | main | edit_num | edit_date | dict_id
145145----+---------+------------+-------+------+----------+-----------+---------
146- 3 | 2 |09-12-2018 | num_1 | 2 | | | 3
147- 4 | 2 |09-12-2018 | num_2 | 1 | | | 3
146+ 3 | 2 |10-10-2010 | num_1 | 2 | | | 3
147+ 4 | 2 |10-10-2010 | num_2 | 1 | | | 3
148148(2 rows)
149149
150150EXECUTE getbyroot(2);
151151 id | root_id | start_date | num | main | edit_num | edit_date | dict_id
152152----+---------+------------+-------+------+----------+-----------+---------
153- 3 | 2 |09-12-2018 | num_1 | 2 | | | 3
154- 4 | 2 |09-12-2018 | num_2 | 1 | | | 3
153+ 3 | 2 |10-10-2010 | num_1 | 2 | | | 3
154+ 4 | 2 |10-10-2010 | num_2 | 1 | | | 3
155155(2 rows)
156156
157157EXECUTE getbyroot(2);
158158 id | root_id | start_date | num | main | edit_num | edit_date | dict_id
159159----+---------+------------+-------+------+----------+-----------+---------
160- 3 | 2 |09-12-2018 | num_1 | 2 | | | 3
161- 4 | 2 |09-12-2018 | num_2 | 1 | | | 3
160+ 3 | 2 |10-10-2010 | num_1 | 2 | | | 3
161+ 4 | 2 |10-10-2010 | num_2 | 1 | | | 3
162162(2 rows)
163163
164164EXECUTE getbyroot(2);
165165 id | root_id | start_date | num | main | edit_num | edit_date | dict_id
166166----+---------+------------+-------+------+----------+-----------+---------
167- 3 | 2 |09-12-2018 | num_1 | 2 | | | 3
168- 4 | 2 |09-12-2018 | num_2 | 1 | | | 3
167+ 3 | 2 |10-10-2010 | num_1 | 2 | | | 3
168+ 4 | 2 |10-10-2010 | num_2 | 1 | | | 3
169169(2 rows)
170170
171171-- errors usually start here
172172EXECUTE getbyroot(2);
173173 id | root_id | start_date | num | main | edit_num | edit_date | dict_id
174174----+---------+------------+-------+------+----------+-----------+---------
175- 3 | 2 |09-12-2018 | num_1 | 2 | | | 3
176- 4 | 2 |09-12-2018 | num_2 | 1 | | | 3
175+ 3 | 2 |10-10-2010 | num_1 | 2 | | | 3
176+ 4 | 2 |10-10-2010 | num_2 | 1 | | | 3
177177(2 rows)
178178
179179EXECUTE getbyroot(2);
180180 id | root_id | start_date | num | main | edit_num | edit_date | dict_id
181181----+---------+------------+-------+------+----------+-----------+---------
182- 3 | 2 |09-12-2018 | num_1 | 2 | | | 3
183- 4 | 2 |09-12-2018 | num_2 | 1 | | | 3
182+ 3 | 2 |10-10-2010 | num_1 | 2 | | | 3
183+ 4 | 2 |10-10-2010 | num_2 | 1 | | | 3
184184(2 rows)
185185
186186EXPLAIN EXECUTE getbyroot(2);