Re: Syntax question about returning value from an insert
Adrian Klaver <[email protected]> Wed, 25 Dec 2019 21:17:22 -0800
| Newsgroups | gmane.comp.db.postgresql.general |
|---|---|
| Message-ID | <[email protected]> |
On 12/25/19 4:48 PM, Rob Sargent wrote: > > >> 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 No, my nose is twitching also. expenditures use the category id? >> >> > -- Adrian Klaver [email protected]