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)
Список
Дерево обсуждения
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 по дате отправления