Re: All tested on the same column, some functions work, some don't?

Am I right that this clause is embedded in a SQL statement like

create table ... as select ... <clause> ... from <table> with data; where <table> has columns UNIQUE_ROW_IDENTIFIER and MY_CODE ?

Yes, precisely. :)