From: | Henry Ortega <juandelacruz(at)gmail(dot)com> |
---|---|
To: | Ragnar Hafstað <gnari(at)simnet(dot)is> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: insert only if conditions are met? |
Date: | 2005-08-31 16:49:14 |
Message-ID: | 2bffcc33050831094957be1b4a@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Ok. Here's TABLE A
emp date hours type
JSMITH 08-15-2005 5 WORK
JSMITH 08-15-2005 3 WORK
JSMITH 08-25-2005 6 WORK
I want to insert the ff:
1.) JSMITH 08-15-2005 8 VAC
2.) DOE 08-16-2005 8 VAC
#1 should fail because there is already 8 hours entered as being
Worked on 08-15-2005 (same date).
Any suggestions?
On 8/31/05, Ragnar Hafstað <gnari(at)simnet(dot)is> wrote:
>
> On Wed, 2005-08-31 at 11:49 -0400, Henry Ortega wrote:
> > What I am trying to do is
> > * Insert a record for EMPLOYEE A to TABLE A
> > IF
> > the sum of the hours worked by EMPLOYEE A on TABLE A
> > is not equal to N
> >
> > Is this possible?
>
> Sure, given a suitable schema
>
> It is not clear to me, if the hours worked are
> to be found in the same table you want to insert
> into, or not.
>
> gnari
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jim C. Nasby | 2005-08-31 19:54:06 | Re: insert only if conditions are met? |
Previous Message | Ragnar Hafstað | 2005-08-31 16:44:58 | Re: insert only if conditions are met? |