On Thu, Dec 26, 2019 at 09:06:03AM -0500, Tom Lane wrote: > stan <stanb@xxxxxxxxx> 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.) Thanks, that was my mistake. -- "They that would give up essential liberty for temporary safety deserve neither liberty nor safety." -- Benjamin Franklin
