Ari Entlich <atrigent(at)ccs(dot)neu(dot)edu> writes:
> I do, however, think it should definitely be documented somewhere that functions cannot be used to get around the lack of check statement subqueries, because the ordering of operations is wrong.
That statement seems to me to be complete nonsense. You can certainly
put a query into a function invoked by CHECK. It may be that there's
some particular use-case that this doesn't work for, but that does not
justify a blanket statement that it "doesn't work".
regards, tom lane