stan <stanb(at)panix(dot)com> writes:
> When I try to insert this function I get an error on the following line:
> _bom_name_key = ( SELECT
> I actually pretty much get a syntax error whatever is at this line.
> Can someone please explain what I am doing wrong?
I think you're misunderstanding where to put the WITH. That's just
part of the SQL statement as far as plpgsql is concerned, so what
you need to do to use a WITH clause in a variable assignment is
to write
variable := WITH ... SELECT ... ;
(At least, I think that will work; what you're doing definitely
won't.)
regards, tom lane