information_schema.routines.is_deterministic

Note:

Whether the routine is deterministic (can produce only one result for a given list of parameters) or not.

Note:

Whether the routine is deterministic (can produce only one result for a given list of parameters) or not.

Note:

If the function is declared immutable (called deterministic in the SQL standard), then YES, else NO. (You cannot query the other volatility levels available in PostgreSQL through the information schema.)

Note:

If the function is declared immutable (called deterministic in the SQL standard), then YES, else NO. (You cannot query the other volatility levels available in PostgreSQL through the information schema.)

Note:

Always NULL.

Note:

Returns YES if the routine is deterministic. Returns NO if the routine is nondeterministic. Always returns NO for stored procedures.