| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Rob Sargent <robjsargent(at)gmail(dot)com>, stan <stanb(at)panix(dot)com> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Syntax question about returning value from an insert |
| Date: | 2019-12-26 05:17:22 |
| Message-ID: | c831f120-b3a4-4996-75c1-0517ceef5424@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 12/25/19 4:48 PM, Rob Sargent wrote:
>
>
>> On Dec 25, 2019, at 3:10 PM, stan <stanb(at)panix(dot)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 definition of cost categories and then project specific
No, my nose is twitching also.
expenditures use the category id?
>>
>>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | stan | 2019-12-26 12:10:55 | Re: Syntax question about returning value from an insert |
| Previous Message | Adrian Klaver | 2019-12-26 05:16:50 | Re: Syntax question about returning value from an insert |