Tom Lane wrote:
> Alex Pilosov <alex(at)pilosoft(dot)com> writes:
> >> Consider statement boundaries in an SQL function --- the
> >> function is probably being called from some outer statement, so
> >> advancing now() within the function would violate the spec constraint
> >> with respect to the outer statement.
> > Postgres doesn't have an idea of what a 'top-level' statement is? I.E.
> > statement as submitted by a client (libpq)?
>
> There's never been any reason to make such a distinction.
There's already a distinction.
Snapshot is made per top-level statement and functions/subqueries
use the same snapshot as that of top-level statement.
Regards.
Hiroshi Inoue