!= ANY(array) does not behave as expected

Dear Postgres users, I like using ANY(array) instead of IN (...), as we can pass the array as binary data, avoiding the need to render its contents (which might be integers) into a SQL string, for Postgres to parse them back into integers again, and it also works with an empty list

Re: Adding identity column to a non-empty table

Hi all, I'd like to resurrect this thread, as it seems that there was no definitive answer: https://www.postgresql.org/message-id/959f28ef-4245-8349-eff9-0ff5f666df03%40lucee.org Does anyone know how to add an IDENTITY column to an existing non-empty table? Like Igal, I get the error message "col