Leon Starr <leon_starr(at)modelint(dot)com> writes:
> I tried this and it failed (see embedded comments):
> select * into my_paragraph from paragraph where
> form = p_form and
> number = ( select method_paragraph_new( p_form, 0, p_append ) );
> -- Inner expression above inserts a new row in the 'paragraph' table which
> -- just happens to be the one I want selected by the outer select-into expression
You're apparently expecting that the row inserted by
method_paragraph_new() will be seen by the already-in-progress outer
query? That won't happen. A SELECT will only see rows that exist
when it starts execution. This is a feature, not a bug.
regards, tom lane