postgresqlstored-proceduresno-op

What to use as a NOOP in PostgreSQL?

I have need of a placeholder while I develop some stored procedures in PostgreSQL 8.4. I'd typically use some sort of executable noop (one that's not going to generate an error when an attempt is made to execute it), but based upon a cursory examination, there doesn't appear to be such a function in PostgreSQL. What alternatives exist?

Solution

  • [Update 2025-03-04]

    SELECT; appears to work and presumably has minimal side-effects.

    (The original answer, "NULL;" no longer works as an expression)