Re: Syntax question about returning value from an insert

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: stan <stanb(at)panix(dot)com>
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Syntax question about returning value from an insert
Date: 2019-12-26 00:48:55
Message-ID: 0BC9EA4D-B1F0-4354-BE2C-80BA8E12097B@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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 expenditures use the category id?
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2019-12-26 05:16:50 Re: Syntax question about returning value from an insert
Previous Message stan 2019-12-25 23:58:57 Re: Syntax question about returning value from an insert