postgresql-sort数组由每个元素中的单词组成 [英] postgresql-sort array by words in each elements
本文介绍了postgresql-sort数组由每个元素中的单词组成的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
有字符串数组
ARRAY [' CAT',' CAT DOG CAT',< span class =code-string>' DOG Cat']
现在我想根据每个元素中的单词数对这个数组进行排序。我试过但是没有取得任何成功。
我想要这个输出
ARRAY [' CAT DOG CAT',' DOG CAT',' Cat']
我怎么能这样做?
解决方案
我不确定,但它会是这样的:
SELECT *
FROM (
SELECT unnest(ARRAY ['' CAT',' CAT DOG CAT' ,' DOG Cat']) AS Aminals,unfst(ARRAY [ 3 , 1 , 2 ]) AS SortOrder
) AS foo
ORDER BY SortOrder
见这里:
8.14。数组 [ ^ ]
9.17。数组函数和运算符 [ ^
There is string array
ARRAY['CAT','CAT DOG CAT','DOG Cat']
Now i want to sort this array on count of words in each element. I have tried but cannot get any success.
I want this output
ARRAY['CAT DOG CAT','DOG CAT','Cat']
How i can do this?
解决方案
I'm not sure, but it would be something like that:
SELECT * FROM ( SELECT unnest(ARRAY['CAT','CAT DOG CAT','DOG Cat']) AS Aminals, unnest(ARRAY[3,1,2]) AS SortOrder ) AS foo ORDER BY SortOrder
See here:
8.14. Arrays[^]
9.17. Array Functions and Operators[^]
这篇关于postgresql-sort数组由每个元素中的单词组成的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文