Re: insert only if conditions are met?

Поиск
Список
Период
Сортировка
Искать
От
Ragnar Hafstað
Тема
Re: insert only if conditions are met?
Дата
Msg-id
1125506698.2605.22.camel@localhost.localdomain
Ответ на
Список
Дерево обсуждения
insert only if conditions are met? Henry Ortega <juandelacruz@gmail.com>
Re: insert only if conditions are met? Michael Fuhr <mike@fuhr.org>
Re: insert only if conditions are met? Tom Lane <tgl@sss.pgh.pa.us>
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




В списке pgsql-sql по дате отправления
От: Henry Ortega
Дата:
От: Henry Ortega
Дата:
FAQ