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

From Adrian Klaver
Subject Re: Syntax question about returning value from an insert
Date
Msg-id c831f120-b3a4-4996-75c1-0517ceef5424@aklaver.com
Whole thread Raw
In response to Re: Syntax question about returning value from an insert  (Rob Sargent <robjsargent@gmail.com>)
Responses Re: Syntax question about returning value from an insert
List pgsql-general
On 12/25/19 4:48 PM, Rob Sargent wrote:
> 
> 
>> 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 
 

No, my nose is twitching also.

expenditures use the category id?
>>
>>
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

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