Re: What am I doing wrong here?

Jayadevan M <[email protected]> Thu, 26 Dec 2019 19:34:28 +0530

Newsgroups	gmane.comp.db.postgresql.general
Message-ID	<CAFS1N4hobXSLNgE0nQM-9BT5_nAW6XOXJhQ0qYLUkE5gAzDW5g@mail.gmail.com>

Hi,


On Thu, Dec 26, 2019 at 7:06 PM stan <[email protected]> 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 ;
Regards,
Jayadevan