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? > >