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.

PostgreSQL - Using contrib

JuarezNJunior's profile image JuarezNJunior posted 7 years ago in Running SQL scripts Permalink
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
ansgar's profile image ansgar posted 7 years ago Permalink
I get the same error from the PG server.

What exactly is "intarray contrib"?
JuarezNJunior's profile image JuarezNJunior posted 7 years ago Permalink
execute "create extension intarray"

http://www.postgresql.org/docs/9.3/static/intarray.html

Tks

Please login to leave a reply, or register at first.




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.