projects
/
xtuple
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
f3157b0
)
Add returning to insert rule.
author
Ben Thompson
<ben@xtuple.com>
Tue, 20 May 2014 22:41:55 +0000
(18:41 -0400)
committer
Ben Thompson
<ben@xtuple.com>
Tue, 20 May 2014 22:41:55 +0000
(18:41 -0400)
enyo-client/database/source/xt/views/invcheadinfo.sql
patch
|
blob
|
history
diff --git
a/enyo-client/database/source/xt/views/invcheadinfo.sql
b/enyo-client/database/source/xt/views/invcheadinfo.sql
index
07efb4e
..
d762d6c
100644
(file)
--- a/
enyo-client/database/source/xt/views/invcheadinfo.sql
+++ b/
enyo-client/database/source/xt/views/invcheadinfo.sql
@@
-131,7
+131,18
@@
insert into invchead (
new.invchead_void,
new.invchead_saletype_id,
new.invchead_shipzone_id
-);
+)
+
+returning invchead.*,
+ null::numeric,
+ null::numeric,
+ null::numeric,
+ null::numeric,
+ null::numeric,
+ null::numeric,
+ null::numeric,
+ null::date,
+ null::date;
create or replace rule "_UPDATE" as on update to xt.invcheadinfo do instead