blog.usatenko.name
Thursday, February 17, 2011
How to sort similar string with words in mixed up order
select distinct on (array_to_string((select array_agg(xx) from (select lower(x) from
unnest(string_to_array(lower(value), ' ')) x order by x) xx), ' ')) value from dup;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Followers
Blog Archive
►
2014
(1)
►
June
(1)
►
2013
(1)
►
October
(1)
►
2012
(1)
►
October
(1)
▼
2011
(8)
►
August
(1)
►
June
(1)
►
May
(1)
►
March
(1)
▼
February
(2)
How to sort similar string with words in mixed up ...
How to sort similar string with words in mixed up ...
►
January
(2)
►
2010
(18)
►
December
(1)
►
November
(5)
►
October
(2)
►
September
(1)
►
August
(2)
►
July
(1)
►
June
(4)
►
March
(1)
►
February
(1)
►
2009
(10)
►
December
(3)
►
November
(1)
►
October
(5)
►
September
(1)
About Me
au
View my complete profile
No comments:
Post a Comment