/SQL/Array aggre distinct postgres

Array aggre distinct postgres

Array aggre distinct postgres

SELECT ARRAY(SELECT DISTINCT e FROM unnest(ARRAY[a,b,c,d]) AS a(e))
FROM ( VALUES
  ('foo', 'bar', 'foo', 'baz' )
) AS t(a,b,c,d);

0

Source: dba.stackexchange.com

Similar codes

0 vote233 views1 answer
Mysql convert column to uppercase
SQL
0 vote290 views1 answer
Sql script get all stored procedures from database
SQL
0 vote266 views1 answer
Redirection 301 htaccess nom de domaine
SQL
4 votes262 views2 answers
Tables in sql
SQL
0 vote240 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
0 vote279 views1 answer
Get db connection detail from sql developer profile
SQL
0 vote286 views1 answer
Transaction database with php
SQL
0 vote234 views1 answer
Connection error in mysql workbench
SQL
0 vote360 views1 answer
How to check common records in 2 table
SQL
0 vote274 views1 answer
Sql server convert date to weekday
SQL

Share