Im using intarray contrib
pgadmin III:
select ARRAY[1,2,3,4] - ARRAY[1,2,3]
result:
'{4}'
heidiSQL:
select ARRAY[1,2,3,4] - ARRAY[1,2,3]
ERROR: operator does not exist: integer[] - integer[]
PostgreSQL 9.3.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-4), 64-bit
Tks
Ads were blocked - no problem. But keep in mind that developing HeidiSQL,
user support and hosting takes time and money. You may want to
send a donation instead.