Re: What am I doing wrong here?

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

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