CREATE TABLE t1(
//The column ordering is taken from here
pk integer primary key,
c1 char( 30),
c2 float,
c3 double );
CREATE PROCEDURE t1_insert ()
RESULT( pk integer, c1 char(30), c3 double )
begin
...
end
CREATE PUBLICATION WITH SCRIPTED UPLOAD p1(
// Order of columns here is ignored
TABLE t1( c3, pk, c1 ) USING (
PROCEDURE t1_insert FOR UPLOAD INSERT
)
)