postgresql-sort数组由每个元素中的单词组成 [英] postgresql-sort array by words in each elements

问题描述

有字符串数组

 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屋！