Re: What am I doing wrong here?

On Thu, Dec 26, 2019 at 09:06:03AM -0500, Tom Lane wrote:
> stan <stanb@panix.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.)

Thanks, that was my mistake.
-- 
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
                        -- Benjamin Franklin