forked frompostgres/postgres
- Notifications
You must be signed in to change notification settings - Fork6
Commit592c88a
committed
Remove the aggregate form of ts_rewrite(), since it doesn't work as desired
if there are zero rows to aggregate over, and the API seems both conceptuallyand notationally ugly anyway. We should look for something that improveson the tsquery-and-text-SELECT version (which is also pretty ugly but atleast it works...), but it seems that will take query infrastructure thatdoesn't exist today. (Hm, I wonder if there's anything in or near SQL2003window functions that would help?) Per discussion.1 parent07d0a37 commit592c88a
File tree
8 files changed
+48
-214
lines changed- doc/src/sgml
- src
- backend/utils/adt
- include
- catalog
- tsearch
- test/regress
- expected
- sql
8 files changed
+48
-214
lines changedLines changed: 1 addition & 28 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
1 |
| - | |
| 1 | + | |
2 | 2 |
| |
3 | 3 |
| |
4 | 4 |
| |
| |||
1456 | 1456 |
| |
1457 | 1457 |
| |
1458 | 1458 |
| |
1459 |
| - | |
1460 |
| - | |
1461 |
| - | |
1462 |
| - | |
1463 |
| - | |
1464 |
| - | |
1465 |
| - | |
1466 |
| - | |
1467 |
| - | |
1468 |
| - | |
1469 |
| - | |
1470 |
| - | |
1471 |
| - | |
1472 |
| - | |
1473 |
| - | |
1474 |
| - | |
1475 |
| - | |
1476 |
| - | |
1477 |
| - | |
1478 |
| - | |
1479 |
| - | |
1480 |
| - | |
1481 |
| - | |
1482 |
| - | |
1483 |
| - | |
1484 |
| - | |
1485 |
| - | |
1486 | 1459 |
| |
1487 | 1460 |
| |
1488 | 1461 |
| |
|
Lines changed: 3 additions & 131 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
7 | 7 |
| |
8 | 8 |
| |
9 | 9 |
| |
10 |
| - | |
| 10 | + | |
11 | 11 |
| |
12 | 12 |
| |
13 | 13 |
| |
| |||
250 | 250 |
| |
251 | 251 |
| |
252 | 252 |
| |
253 |
| - | |
254 |
| - | |
255 |
| - | |
256 |
| - | |
257 |
| - | |
258 |
| - | |
259 |
| - | |
260 |
| - | |
261 |
| - | |
262 |
| - | |
263 |
| - | |
264 |
| - | |
265 |
| - | |
266 |
| - | |
267 |
| - | |
268 |
| - | |
269 |
| - | |
270 |
| - | |
271 |
| - | |
272 |
| - | |
273 |
| - | |
274 |
| - | |
275 |
| - | |
276 |
| - | |
277 |
| - | |
278 |
| - | |
279 |
| - | |
280 |
| - | |
281 |
| - | |
282 |
| - | |
283 |
| - | |
284 |
| - | |
285 |
| - | |
286 |
| - | |
287 |
| - | |
288 |
| - | |
289 |
| - | |
290 |
| - | |
291 |
| - | |
292 |
| - | |
293 |
| - | |
294 |
| - | |
295 |
| - | |
296 |
| - | |
297 |
| - | |
298 |
| - | |
299 |
| - | |
300 |
| - | |
301 |
| - | |
302 |
| - | |
303 |
| - | |
304 |
| - | |
305 |
| - | |
306 |
| - | |
307 |
| - | |
308 |
| - | |
309 |
| - | |
310 |
| - | |
311 |
| - | |
312 |
| - | |
313 |
| - | |
314 |
| - | |
315 |
| - | |
316 |
| - | |
317 |
| - | |
318 |
| - | |
319 |
| - | |
320 |
| - | |
321 |
| - | |
322 |
| - | |
323 |
| - | |
324 |
| - | |
325 |
| - | |
326 |
| - | |
327 |
| - | |
328 |
| - | |
329 |
| - | |
330 |
| - | |
331 |
| - | |
332 |
| - | |
333 |
| - | |
334 |
| - | |
335 |
| - | |
336 |
| - | |
337 |
| - | |
338 |
| - | |
339 |
| - | |
340 |
| - | |
341 |
| - | |
342 |
| - | |
343 |
| - | |
344 |
| - | |
345 |
| - | |
346 |
| - | |
347 |
| - | |
348 |
| - | |
349 |
| - | |
350 |
| - | |
351 |
| - | |
352 |
| - | |
353 |
| - | |
354 |
| - | |
355 |
| - | |
356 |
| - | |
357 |
| - | |
358 |
| - | |
359 |
| - | |
360 |
| - | |
361 |
| - | |
362 |
| - | |
363 |
| - | |
364 |
| - | |
365 |
| - | |
366 |
| - | |
367 |
| - | |
368 |
| - | |
369 |
| - | |
370 |
| - | |
371 |
| - | |
372 |
| - | |
373 |
| - | |
374 |
| - | |
375 |
| - | |
376 |
| - | |
377 |
| - | |
378 |
| - | |
379 |
| - | |
380 |
| - | |
381 |
| - | |
| 253 | + | |
382 | 254 |
| |
383 | 255 |
| |
384 | 256 |
| |
| |||
505 | 377 |
| |
506 | 378 |
| |
507 | 379 |
| |
508 |
| - | |
| 380 | + | |
509 | 381 |
| |
510 | 382 |
| |
511 | 383 |
| |
|
Lines changed: 2 additions & 2 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
37 | 37 |
| |
38 | 38 |
| |
39 | 39 |
| |
40 |
| - | |
| 40 | + | |
41 | 41 |
| |
42 | 42 |
| |
43 | 43 |
| |
| |||
53 | 53 |
| |
54 | 54 |
| |
55 | 55 |
| |
56 |
| - | |
| 56 | + | |
57 | 57 |
| |
58 | 58 |
|
Lines changed: 1 addition & 4 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
8 | 8 |
| |
9 | 9 |
| |
10 | 10 |
| |
11 |
| - | |
| 11 | + | |
12 | 12 |
| |
13 | 13 |
| |
14 | 14 |
| |
| |||
226 | 226 |
| |
227 | 227 |
| |
228 | 228 |
| |
229 |
| - | |
230 |
| - | |
231 |
| - | |
232 | 229 |
| |
233 | 230 |
| |
234 | 231 |
| |
|
Lines changed: 3 additions & 9 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
7 | 7 |
| |
8 | 8 |
| |
9 | 9 |
| |
10 |
| - | |
| 10 | + | |
11 | 11 |
| |
12 | 12 |
| |
13 | 13 |
| |
| |||
4258 | 4258 |
| |
4259 | 4259 |
| |
4260 | 4260 |
| |
4261 |
| - | |
| 4261 | + | |
4262 | 4262 |
| |
4263 |
| - | |
4264 |
| - | |
4265 |
| - | |
4266 |
| - | |
4267 |
| - | |
4268 |
| - | |
4269 |
| - | |
| 4263 | + | |
4270 | 4264 |
| |
4271 | 4265 |
| |
4272 | 4266 |
| |
|
Lines changed: 1 addition & 3 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
5 | 5 |
| |
6 | 6 |
| |
7 | 7 |
| |
8 |
| - | |
| 8 | + | |
9 | 9 |
| |
10 | 10 |
| |
11 | 11 |
| |
| |||
285 | 285 |
| |
286 | 286 |
| |
287 | 287 |
| |
288 |
| - | |
289 |
| - | |
290 | 288 |
| |
291 | 289 |
| |
292 | 290 |
| |
|
Lines changed: 21 additions & 21 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
676 | 676 |
| |
677 | 677 |
| |
678 | 678 |
| |
679 |
| - | |
| 679 | + | |
680 | 680 |
| |
681 | 681 |
| |
682 | 682 |
| |
683 | 683 |
| |
684 | 684 |
| |
685 |
| - | |
| 685 | + | |
686 | 686 |
| |
687 | 687 |
| |
688 | 688 |
| |
689 | 689 |
| |
690 | 690 |
| |
691 |
| - | |
| 691 | + | |
692 | 692 |
| |
693 | 693 |
| |
694 |
| - | |
| 694 | + | |
695 | 695 |
| |
696 | 696 |
| |
697 |
| - | |
| 697 | + | |
698 | 698 |
| |
699 | 699 |
| |
700 | 700 |
| |
| |||
723 | 723 |
| |
724 | 724 |
| |
725 | 725 |
| |
726 |
| - | |
| 726 | + | |
727 | 727 |
| |
728 | 728 |
| |
729 | 729 |
| |
730 | 730 |
| |
731 | 731 |
| |
732 |
| - | |
| 732 | + | |
733 | 733 |
| |
734 | 734 |
| |
735 |
| - | |
| 735 | + | |
736 | 736 |
| |
737 | 737 |
| |
738 |
| - | |
| 738 | + | |
739 | 739 |
| |
740 | 740 |
| |
741 | 741 |
| |
742 | 742 |
| |
743 | 743 |
| |
744 |
| - | |
| 744 | + | |
745 | 745 |
| |
746 | 746 |
| |
747 | 747 |
| |
748 | 748 |
| |
749 | 749 |
| |
750 |
| - | |
| 750 | + | |
751 | 751 |
| |
752 | 752 |
| |
753 |
| - | |
| 753 | + | |
754 | 754 |
| |
755 | 755 |
| |
756 |
| - | |
| 756 | + | |
757 | 757 |
| |
758 | 758 |
| |
759 | 759 |
| |
| |||
784 | 784 |
| |
785 | 785 |
| |
786 | 786 |
| |
787 |
| - | |
| 787 | + | |
788 | 788 |
| |
789 | 789 |
| |
790 | 790 |
| |
791 | 791 |
| |
792 | 792 |
| |
793 |
| - | |
| 793 | + | |
794 | 794 |
| |
795 | 795 |
| |
796 |
| - | |
| 796 | + | |
797 | 797 |
| |
798 | 798 |
| |
799 |
| - | |
| 799 | + | |
800 | 800 |
| |
801 | 801 |
| |
802 | 802 |
| |
803 | 803 |
| |
804 | 804 |
| |
805 |
| - | |
| 805 | + | |
806 | 806 |
| |
807 | 807 |
| |
808 | 808 |
| |
809 | 809 |
| |
810 | 810 |
| |
811 |
| - | |
| 811 | + | |
812 | 812 |
| |
813 | 813 |
| |
814 |
| - | |
| 814 | + | |
815 | 815 |
| |
816 | 816 |
| |
817 |
| - | |
| 817 | + | |
818 | 818 |
| |
819 | 819 |
| |
820 | 820 |
| |
|
0 commit comments
Comments
(0)