#PostgreSQL / #SQL question:

SELECT my_func(x.some_col)
FROM x
ORDER BY x.some_col

AFAIK this doesn& #39;t guarantee the order in which `my_func` is called. How can I force the order without relying on undefined behavior? Is it possible without plpgsql?

my_func() in this case has DML side-effects, that& #39;s why I care about the order.

The reason I ask is that the PostgreSQL docs indicate that the `ORDER BY` is usually evaluated *after* the select output expression.

My experiment& #39;s show that this often isn& #39;t the case, but I hate to rely on undocumented implementation details for the correctness of my code.