pg_trgm.out

PostgreSQL 8.1.4的源码 适用于Linux下的开源数据库系统

 qwertyu0412 |      0.5
 qwertyu0413 |      0.5
 qwertyu0414 |      0.5
 qwertyu0415 |      0.5
 qwertyu0416 |      0.5
 qwertyu0417 |      0.5
 qwertyu0418 |      0.5
 qwertyu0419 |      0.5
 qwertyu0420 |      0.5
 qwertyu0421 |      0.5
 qwertyu0422 |      0.5
 qwertyu0423 |      0.5
 qwertyu0424 |      0.5
 qwertyu0425 |      0.5
 qwertyu0426 |      0.5
 qwertyu0427 |      0.5
 qwertyu0428 |      0.5
 qwertyu0429 |      0.5
 qwertyu0430 |      0.5
 qwertyu0431 |      0.5
 qwertyu0432 |      0.5
 qwertyu0433 |      0.5
 qwertyu0434 |      0.5
 qwertyu0435 |      0.5
 qwertyu0436 |      0.5
 qwertyu0437 |      0.5
 qwertyu0438 |      0.5
 qwertyu0439 |      0.5
 qwertyu0440 |      0.5
 qwertyu0441 |      0.5
 qwertyu0442 |      0.5
 qwertyu0443 |      0.5
 qwertyu0444 |      0.5
 qwertyu0445 |      0.5
 qwertyu0446 |      0.5
 qwertyu0447 |      0.5
 qwertyu0448 |      0.5
 qwertyu0449 |      0.5
 qwertyu0450 |      0.5
 qwertyu0451 |      0.5
 qwertyu0452 |      0.5
 qwertyu0453 |      0.5
 qwertyu0454 |      0.5
 qwertyu0455 |      0.5
 qwertyu0456 |      0.5
 qwertyu0457 |      0.5
 qwertyu0458 |      0.5
 qwertyu0459 |      0.5
 qwertyu0460 |      0.5
 qwertyu0461 |      0.5
 qwertyu0462 |      0.5
 qwertyu0463 |      0.5
 qwertyu0464 |      0.5
 qwertyu0465 |      0.5
 qwertyu0466 |      0.5
 qwertyu0467 |      0.5
 qwertyu0468 |      0.5
 qwertyu0469 |      0.5
 qwertyu0470 |      0.5
 qwertyu0471 |      0.5
 qwertyu0472 |      0.5
 qwertyu0473 |      0.5
 qwertyu0474 |      0.5
 qwertyu0475 |      0.5
 qwertyu0476 |      0.5
 qwertyu0477 |      0.5
 qwertyu0478 |      0.5
 qwertyu0479 |      0.5
 qwertyu0480 |      0.5
 qwertyu0481 |      0.5
 qwertyu0482 |      0.5
 qwertyu0483 |      0.5
 qwertyu0484 |      0.5
 qwertyu0485 |      0.5
 qwertyu0486 |      0.5
 qwertyu0487 |      0.5
 qwertyu0489 |      0.5
 qwertyu0490 |      0.5
 qwertyu0491 |      0.5
 qwertyu0492 |      0.5
 qwertyu0493 |      0.5
 qwertyu0494 |      0.5
 qwertyu0495 |      0.5
 qwertyu0496 |      0.5
 qwertyu0497 |      0.5
 qwertyu0498 |      0.5
 qwertyu0499 |      0.5
 qwertyu0500 |      0.5
 qwertyu0501 |      0.5
 qwertyu0502 |      0.5
 qwertyu0503 |      0.5
 qwertyu0504 |      0.5
 qwertyu0505 |      0.5
 qwertyu0506 |      0.5
 qwertyu0507 |      0.5
 qwertyu0508 |      0.5
 qwertyu0509 |      0.5
 qwertyu0510 |      0.5
 qwertyu0511 |      0.5
 qwertyu0512 |      0.5
 qwertyu0513 |      0.5
 qwertyu0514 |      0.5
 qwertyu0515 |      0.5
 qwertyu0516 |      0.5
 qwertyu0517 |      0.5
 qwertyu0518 |      0.5
 qwertyu0519 |      0.5
 qwertyu0520 |      0.5
 qwertyu0521 |      0.5
 qwertyu0522 |      0.5
 qwertyu0523 |      0.5
 qwertyu0524 |      0.5
 qwertyu0525 |      0.5
 qwertyu0526 |      0.5
 qwertyu0527 |      0.5
 qwertyu0528 |      0.5
 qwertyu0529 |      0.5
 qwertyu0530 |      0.5
 qwertyu0531 |      0.5
 qwertyu0532 |      0.5
 qwertyu0533 |      0.5
 qwertyu0534 |      0.5
 qwertyu0535 |      0.5
 qwertyu0536 |      0.5
 qwertyu0537 |      0.5
 qwertyu0538 |      0.5
 qwertyu0539 |      0.5
 qwertyu0540 |      0.5
 qwertyu0541 |      0.5
 qwertyu0542 |      0.5
 qwertyu0543 |      0.5
 qwertyu0544 |      0.5
 qwertyu0545 |      0.5
 qwertyu0546 |      0.5
 qwertyu0547 |      0.5
 qwertyu0548 |      0.5
 qwertyu0549 |      0.5
 qwertyu0550 |      0.5
 qwertyu0551 |      0.5
 qwertyu0552 |      0.5
 qwertyu0553 |      0.5
 qwertyu0554 |      0.5
 qwertyu0555 |      0.5
 qwertyu0556 |      0.5
 qwertyu0557 |      0.5
 qwertyu0558 |      0.5
 qwertyu0559 |      0.5
 qwertyu0560 |      0.5
 qwertyu0561 |      0.5
 qwertyu0562 |      0.5
 qwertyu0563 |      0.5
 qwertyu0564 |      0.5
 qwertyu0565 |      0.5
 qwertyu0566 |      0.5
 qwertyu0567 |      0.5
 qwertyu0568 |      0.5
 qwertyu0569 |      0.5
 qwertyu0570 |      0.5
 qwertyu0571 |      0.5
 qwertyu0572 |      0.5
 qwertyu0573 |      0.5
 qwertyu0574 |      0.5
 qwertyu0575 |      0.5
 qwertyu0576 |      0.5
 qwertyu0577 |      0.5
 qwertyu0578 |      0.5
 qwertyu0579 |      0.5
 qwertyu0580 |      0.5
 qwertyu0581 |      0.5
 qwertyu0582 |      0.5
 qwertyu0583 |      0.5
 qwertyu0584 |      0.5
 qwertyu0585 |      0.5
 qwertyu0586 |      0.5
 qwertyu0587 |      0.5
 qwertyu0589 |      0.5
 qwertyu0590 |      0.5
 qwertyu0591 |      0.5
 qwertyu0592 |      0.5
 qwertyu0593 |      0.5
 qwertyu0594 |      0.5
 qwertyu0595 |      0.5
 qwertyu0596 |      0.5
 qwertyu0597 |      0.5
 qwertyu0598 |      0.5
 qwertyu0599 |      0.5
 qwertyu0600 |      0.5
 qwertyu0601 |      0.5
 qwertyu0602 |      0.5
 qwertyu0603 |      0.5
 qwertyu0604 |      0.5
 qwertyu0605 |      0.5
 qwertyu0606 |      0.5
 qwertyu0607 |      0.5
 qwertyu0608 |      0.5
 qwertyu0609 |      0.5
 qwertyu0610 |      0.5
 qwertyu0611 |      0.5
 qwertyu0612 |      0.5
 qwertyu0613 |      0.5
 qwertyu0614 |      0.5
 qwertyu0615 |      0.5
 qwertyu0616 |      0.5
 qwertyu0617 |      0.5
 qwertyu0618 |      0.5
 qwertyu0619 |      0.5
 qwertyu0620 |      0.5
 qwertyu0621 |      0.5
 qwertyu0622 |      0.5
 qwertyu0623 |      0.5
 qwertyu0624 |      0.5
 qwertyu0625 |      0.5
 qwertyu0626 |      0.5
 qwertyu0627 |      0.5
 qwertyu0628 |      0.5
 qwertyu0629 |      0.5
 qwertyu0630 |      0.5
 qwertyu0631 |      0.5
 qwertyu0632 |      0.5
 qwertyu0633 |      0.5
 qwertyu0634 |      0.5
 qwertyu0635 |      0.5
 qwertyu0636 |      0.5
 qwertyu0637 |      0.5
 qwertyu0638 |      0.5
 qwertyu0639 |      0.5
 qwertyu0640 |      0.5
 qwertyu0641 |      0.5
 qwertyu0642 |      0.5
 qwertyu0643 |      0.5
 qwertyu0644 |      0.5
 qwertyu0645 |      0.5
 qwertyu0646 |      0.5
 qwertyu0647 |      0.5
 qwertyu0648 |      0.5
 qwertyu0649 |      0.5
 qwertyu0650 |      0.5
 qwertyu0651 |      0.5
 qwertyu0652 |      0.5
 qwertyu0653 |      0.5
 qwertyu0654 |      0.5
 qwertyu0655 |      0.5
 qwertyu0656 |      0.5
 qwertyu0657 |      0.5
 qwertyu0658 |      0.5
 qwertyu0659 |      0.5
 qwertyu0660 |      0.5
 qwertyu0661 |      0.5
 qwertyu0662 |      0.5
 qwertyu0663 |      0.5
 qwertyu0664 |      0.5
 qwertyu0665 |      0.5
 qwertyu0666 |      0.5
 qwertyu0667 |      0.5
 qwertyu0668 |      0.5
 qwertyu0669 |      0.5
 qwertyu0670 |      0.5
 qwertyu0671 |      0.5
 qwertyu0672 |      0.5
 qwertyu0673 |      0.5
 qwertyu0674 |      0.5
 qwertyu0675 |      0.5
 qwertyu0676 |      0.5
 qwertyu0677 |      0.5
 qwertyu0678 |      0.5
 qwertyu0679 |      0.5
 qwertyu0680 |      0.5
 qwertyu0681 |      0.5
 qwertyu0682 |      0.5
 qwertyu0683 |      0.5
 qwertyu0684 |      0.5
 qwertyu0685 |      0.5
 qwertyu0686 |      0.5
 qwertyu0687 |      0.5
 qwertyu0689 |      0.5
 qwertyu0690 |      0.5
 qwertyu0691 |      0.5
 qwertyu0692 |      0.5
 qwertyu0693 |      0.5
 qwertyu0694 |      0.5
 qwertyu0695 |      0.5
 qwertyu0696 |      0.5
 qwertyu0697 |      0.5
 qwertyu0698 |      0.5
 qwertyu0699 |      0.5
 qwertyu0700 |      0.5
 qwertyu0701 |      0.5
 qwertyu0702 |      0.5
 qwertyu0703 |      0.5
 qwertyu0704 |      0.5
 qwertyu0705 |      0.5
 qwertyu0706 |      0.5
 qwertyu0707 |      0.5
 qwertyu0708 |      0.5
 qwertyu0709 |      0.5
 qwertyu0710 |      0.5
 qwertyu0711 |      0.5
 qwertyu0712 |      0.5
 qwertyu0713 |      0.5
 qwertyu0714 |      0.5
 qwertyu0715 |      0.5
 qwertyu0716 |      0.5
 qwertyu0717 |      0.5
 qwertyu0718 |      0.5
 qwertyu0719 |      0.5
 qwertyu0720 |      0.5
 qwertyu0721 |      0.5
 qwertyu0722 |      0.5
 qwertyu0723 |      0.5
 qwertyu0724 |      0.5
 qwertyu0725 |      0.5
 qwertyu0726 |      0.5
 qwertyu0727 |      0.5
 qwertyu0728 |      0.5
 qwertyu0729 |      0.5
 qwertyu0730 |      0.5
 qwertyu0731 |      0.5
 qwertyu0732 |      0.5
 qwertyu0733 |      0.5
 qwertyu0734 |      0.5
 qwertyu0735 |      0.5
 qwertyu0736 |      0.5
 qwertyu0737 |      0.5
 qwertyu0738 |      0.5
 qwertyu0739 |      0.5
 qwertyu0740 |      0.5
 qwertyu0741 |      0.5
 qwertyu0742 |      0.5
 qwertyu0743 |      0.5
 qwertyu0744 |      0.5
 qwertyu0745 |      0.5
 qwertyu0746 |      0.5
 qwertyu0747 |      0.5
 qwertyu0748 |      0.5
 qwertyu0749 |      0.5
 qwertyu0750 |      0.5
 qwertyu0751 |      0.5
 qwertyu0752 |      0.5
 qwertyu0753 |      0.5
 qwertyu0754 |      0.5
 qwertyu0755 |      0.5
 qwertyu0756 |      0.5
 qwertyu0757 |      0.5
 qwertyu0758 |      0.5
 qwertyu0759 |      0.5
 qwertyu0760 |      0.5
 qwertyu0761 |      0.5
 qwertyu0762 |      0.5
 qwertyu0763 |      0.5
 qwertyu0764 |      0.5
 qwertyu0765 |      0.5
 qwertyu0766 |      0.5
 qwertyu0767 |      0.5
 qwertyu0768 |      0.5
 qwertyu0769 |      0.5
 qwertyu0770 |      0.5
 qwertyu0771 |      0.5
 qwertyu0772 |      0.5
 qwertyu0773 |      0.5
 qwertyu0774 |      0.5
 qwertyu0775 |      0.5
 qwertyu0776 |      0.5
 qwertyu0777 |      0.5
 qwertyu0778 |      0.5
 qwertyu0779 |      0.5
 qwertyu0780 |      0.5
 qwertyu0781 |      0.5
 qwertyu0782 |      0.5
 qwertyu0783 |      0.5
 qwertyu0784 |      0.5
 qwertyu0785 |      0.5
 qwertyu0786 |      0.5
 qwertyu0787 |      0.5
 qwertyu0789 |      0.5
 qwertyu0790 |      0.5
 qwertyu0791 |      0.5
 qwertyu0792 |      0.5
 qwertyu0793 |      0.5
 qwertyu0794 |      0.5
 qwertyu0795 |      0.5
 qwertyu0796 |      0.5
 qwertyu0797 |      0.5
 qwertyu0798 |      0.5
 qwertyu0799 |      0.5
 qwertyu0800 |      0.5
 qwertyu0801 |      0.5
 qwertyu0802 |      0.5
 qwertyu0803 |      0.5
 qwertyu0804 |      0.5
 qwertyu0805 |      0.5
 qwertyu0806 |      0.5
 qwertyu0807 |      0.5
 qwertyu0808 |      0.5
 qwertyu0809 |      0.5
 qwertyu0810 |      0.5
 qwertyu0811 |      0.5
 qwertyu0812 |      0.5
 qwertyu0813 |      0.5
 qwertyu0814 |      0.5
 qwertyu0815 |      0.5
 qwertyu0816 |      0.5
 qwertyu0817 |      0.5
 qwertyu0818 |      0.5
 qwertyu0819 |      0.5
 qwertyu0820 |      0.5
 qwertyu0821 |      0.5
 qwertyu0822 |      0.5
 qwertyu0823 |      0.5
 qwertyu0824 |      0.5
 qwertyu0825 |      0.5
 qwertyu0826 |      0.5
 qwertyu0827 |      0.5
 qwertyu0828 |      0.5
 qwertyu0829 |      0.5
 qwertyu0830 |      0.5
 qwertyu0831 |      0.5
 qwertyu0832 |      0.5
 qwertyu0833 |      0.5
 qwertyu0834 |      0.5
 qwertyu0835 |      0.5
 qwertyu0836 |      0.5
 qwertyu0837 |      0.5
 qwertyu0838 |      0.5
 qwertyu0839 |      0.5
 qwertyu0840 |      0.5
 qwertyu0841 |      0.5
 qwertyu0842 |      0.5
 qwertyu0843 |      0.5
 qwertyu0844 |      0.5
 qwertyu0845 |      0.5
 qwertyu0846 |      0.5
 qwertyu0847 |      0.5
 qwertyu0848 |      0.5
 qwertyu0849 |      0.5
 qwertyu0850 |      0.5
 qwertyu0851 |      0.5
 qwertyu0852 |      0.5
 qwertyu0853 |      0.5
 qwertyu0854 |      0.5
 qwertyu0855 |      0.5
 qwertyu0856 |      0.5
 qwertyu0857 |      0.5
 qwertyu0858 |      0.5
 qwertyu0859 |      0.5
 qwertyu0860 |      0.5
 qwertyu0861 |      0.5
 qwertyu0862 |      0.5
 qwertyu0863 |      0.5
 qwertyu0864 |      0.5
 qwertyu0865 |      0.5
 qwertyu0866 |      0.5
 qwertyu0867 |      0.5
 qwertyu0868 |      0.5
 qwertyu0869 |      0.5
 qwertyu0870 |      0.5
 qwertyu0871 |      0.5
 qwertyu0872 |      0.5
 qwertyu0873 |      0.5
 qwertyu0874 |      0.5
 qwertyu0875 |      0.5
 qwertyu0876 |      0.5
 qwertyu0877 |      0.5
 qwertyu0878 |      0.5
 qwertyu0879 |      0.5
 qwertyu0880 |      0.5
 qwertyu0881 |      0.5
 qwertyu0882 |      0.5
 qwertyu0883 |      0.5
 qwertyu0884 |      0.5
 qwertyu0885 |      0.5
 qwertyu0886 |      0.5
 qwertyu0887 |      0.5
 qwertyu0889 |      0.5
 qwertyu0890 |      0.5
 qwertyu0891 |      0.5
 qwertyu0892 |      0.5
 qwertyu0893 |      0.5
 qwertyu0894 |      0.5
 qwertyu0895 |      0.5
 qwertyu0896 |      0.5
 qwertyu0897 |      0.5
 qwertyu0898 |      0.5
 qwertyu0899 |      0.5
 qwertyu1000 | 0.411765
(1000 rows)

select t,similarity(t,'gwertyu0988') as sml from test_trgm where t % 'gwertyu0988' order by sml desc, t;
      t      |   sml    
-------------+----------
 qwertyu0988 |      0.6
 qwertyu0980 | 0.411765
 qwertyu0981 | 0.411765
 qwertyu0982 | 0.411765
 qwertyu0983 | 0.411765
 qwertyu0984 | 0.411765
 qwertyu0985 | 0.411765
 qwertyu0986 | 0.411765
 qwertyu0987 | 0.411765
 qwertyu0989 | 0.411765
 qwertyu0088 | 0.333333
 qwertyu0098 | 0.333333
 qwertyu0188 | 0.333333
 qwertyu0288 | 0.333333
 qwertyu0388 | 0.333333
 qwertyu0488 | 0.333333
 qwertyu0588 | 0.333333
 qwertyu0688 | 0.333333
 qwertyu0788 | 0.333333
 qwertyu0888 | 0.333333
 qwertyu0900 | 0.333333
 qwertyu0901 | 0.333333
 qwertyu0902 | 0.333333
 qwertyu0903 | 0.333333
 qwertyu0904 | 0.333333
 qwertyu0905 | 0.333333
 qwertyu0906 | 0.333333
 qwertyu0907 | 0.333333
 qwertyu0908 | 0.333333
 qwertyu0909 | 0.333333
 qwertyu0910 | 0.333333
 qwertyu0911 | 0.333333
 qwertyu0912 | 0.333333
 qwertyu0913 | 0.333333
 qwertyu0914 | 0.333333
 qwertyu0915 | 0.333333
 qwertyu0916 | 0.333333
 qwertyu0917 | 0.333333
 qwertyu0918 | 0.333333
 qwertyu0919 | 0.333333
 qwertyu0920 | 0.333333
 qwertyu0921 | 0.333333
 qwertyu0922 | 0.333333
 qwertyu0923 | 0.333333
 qwertyu0924 | 0.333333
 qwertyu0925 | 0.333333
 qwertyu0926 | 0.333333
 qwertyu0927 | 0.333333
 qwertyu0928 | 0.333333
 qwertyu0929 | 0.333333
 qwertyu0930 | 0.333333
 qwertyu0931 | 0.333333
 qwertyu0932 | 0.333333
 qwertyu0933 | 0.333333
 qwertyu0934 | 0.333333
 qwertyu0935 | 0.333333
 qwertyu0936 | 0.333333
 qwertyu0937 | 0.333333
 qwertyu0938 | 0.333333
 qwertyu0939 | 0.333333
 qwertyu0940 | 0.333333
 qwertyu0941 | 0.333333
 qwertyu0942 | 0.333333
 qwertyu0943 | 0.333333
 qwertyu0944 | 0.333333
 qwertyu0945 | 0.333333
 qwertyu0946 | 0.333333
 qwertyu0947 | 0.333333
 qwertyu0948 | 0.333333
 qwertyu0949 | 0.333333
 qwertyu0950 | 0.333333
 qwertyu0951 | 0.333333
 qwertyu0952 | 0.333333
 qwertyu0953 | 0.333333
 qwertyu0954 | 0.333333
 qwertyu0955 | 0.333333
 qwertyu0956 | 0.333333
 qwertyu0957 | 0.333333
 qwertyu0958 | 0.333333
 qwertyu0959 | 0.333333
 qwertyu0960 | 0.333333
 qwertyu0961 | 0.333333
 qwertyu0962 | 0.333333
 qwertyu0963 | 0.333333
 qwertyu0964 | 0.333333
 qwertyu0965 | 0.333333
 qwertyu0966 | 0.333333
 qwertyu0967 | 0.333333
 qwertyu0968 | 0.333333
 qwertyu0969 | 0.333333