Re: What am I doing wrong here?

From: Jayadevan M <maymala(dot)jayadevan(at)gmail(dot)com>
To: stan <stanb(at)panix(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: What am I doing wrong here?
Date: 2019-12-26 14:04:28
Message-ID: CAFS1N4hobXSLNgE0nQM-9BT5_nAW6XOXJhQ0qYLUkE5gAzDW5g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

On Thu, Dec 26, 2019 at 7:06 PM stan <stanb(at)panix(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2019-12-26 14:06:03 Re: What am I doing wrong here?
Previous Message Ray O'Donnell 2019-12-26 13:55:34 Re: What am I doing wrong here?