Is there something in the SQL standard that says functions are guaranteed to executed more than once?
I swear that once I used something like random() and it was only executed once, making it useless for the task at hand. I had to use some trick to ensure it was executed for each row.
I may have used it in the `select` part. Dialect was Oracle's, from memory.
related: https://xkcd.com/221/
replies(5):