Re: What am I doing wrong here? - Mailing list pgsql-general

On Thu, Dec 26, 2019 at 07:34:28PM +0530, Jayadevan M wrote:
> Hi,
> 
> 
> On Thu, Dec 26, 2019 at 7:06 PM stan <stanb@panix.com> wrote:
> 
> >
> >
> > _bom_name_key  = ( SELECT
> >                         project_bom_key
> >                    FROM inserted )
> > ;
> >
> 
> Try rewriting
> _bom_name_key  = ( SELECT
>                         project_bom_key
>                    FROM inserted )
> 
> as        SELECT project_bom_key into _bom_name_key
>                    FROM inserted ;

Thanks for the fast response, That did fix my issue,
-- 
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
                        -- Benjamin Franklin