Re: insert only if conditions are met?

Поиск
Список
Период
Сортировка
От Ragnar Hafstað
Тема Re: insert only if conditions are met?
Дата
Msg-id 1125506698.2605.22.camel@localhost.localdomain
обсуждение исходный текст
Ответ на Re: insert only if conditions are met?  (Henry Ortega <juandelacruz@gmail.com>)
Ответы Re: insert only if conditions are met?  (Henry Ortega <juandelacruz@gmail.com>)
Список pgsql-sql
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
Дата:
Сообщение: Re: insert only if conditions are met?
Следующее
От: Henry Ortega
Дата:
Сообщение: Re: insert only if conditions are met?