/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

1 vote344 views1 answer
Display total number of tables in mysql
SQL
11 votes425 views1 answer
Oracle insert from select
SQL
0 vote406 views2 answers
Mysql show foreign keys
SQL
0 vote356 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
9 votes368 views1 answer
Mysql check date range
SQL
0 vote350 views1 answer
Select from another database
SQL
0 vote366 views1 answer
How to read the potentail error messages in ssis package
SQL
0 vote390 views1 answer
Show specific events on mysql
SQL
8 votes412 views6 answers
Sql insert
SQL
0 vote369 views1 answer
Postgresql create query
SQL

Share