Re: Syntax question about returning value from an insert

Rob Sargent <[email protected]> Wed, 25 Dec 2019 16:48:55 -0800
Newsgroups gmane.comp.db.postgresql.general
Message-ID <[email protected]>

> On Dec 25, 2019, at 3:10 PM, stan <[email protected]> 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 definition of cost categories and then project specific expenditures use the category id?
> 
>