Re: Syntax question about returning value from an insert - Mailing list pgsql-general

From Rob Sargent
Subject Re: Syntax question about returning value from an insert
Date
Msg-id 0BC9EA4D-B1F0-4354-BE2C-80BA8E12097B@gmail.com
Whole thread Raw
In response to Re: Syntax question about returning value from an insert  (stan <stanb@panix.com>)
Responses Re: Syntax question about returning value from an insert
List pgsql-general

> On Dec 25, 2019, at 3:10 PM, stan <stanb@panix.com> wrote:
> There is more that that. There is a project number, so the actuall key
> represents the combination of project number, and cost category, Thire is a
> constraint on T2 that assures that these combinations will be unique.
>
> When the 1st record for a project, that gets charged to the misc. cost
> category is entered, I need to assure that combination gets inserted into
> T2

Is mine the only nose reacting to this? Cost categories aren’t specific to projects are they? Do you need more than a
definitionof cost categories and then project specific expenditures use the category id? 
>
>



pgsql-general by date:

Previous
From: stan
Date:
Subject: Re: Syntax question about returning value from an insert
Next
From: Adrian Klaver
Date:
Subject: Re: Syntax question about returning value from an insert