Home > mailing lists

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

From	Jayadevan M
Subject	Re: What am I doing wrong here?
Date	December 26, 2019 17:04:28
Msg-id	CAFS1N4hobXSLNgE0nQM-9BT5_nAW6XOXJhQ0qYLUkE5gAzDW5g@mail.gmail.com Whole thread Raw
In response to	What am I doing wrong here? (stan <stanb@panix.com>)
Responses	Re: What am I doing wrong here?
List	pgsql-general

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 ;

Regards,

Jayadevan

From: Ray O'Donnell
Date: 26 December 2019, 16:55:34
Subject: Re: What am I doing wrong here?

From: Tom Lane
Date: 26 December 2019, 17:06:03
Subject: Re: What am I doing wrong here?