CREATE TABLE reg_dvizh
(
  id serial NOT NULL,
  id_doc integer,
  str smallint,
  fl smallint,
  id_podr integer,
  id_tov integer,
  kol numeric( 12 , 3 ),
  sum numeric( 19 , 2 ),
  id_val integer,
  obj_doc character( 13 ),
  CONSTRAINT pk_reg_dvizh PRIMARY KEY (id),
  CONSTRAINT fk_reg_dvizh_doc FOREIGN KEY (id_doc)
      REFERENCES doc (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT fk_reg_dvizh_podr FOREIGN KEY (id_podr)
      REFERENCES podr (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT fk_reg_dvizh_tov FOREIGN KEY (id_tov)
      REFERENCES tov (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT fk_reg_dvizh_val FOREIGN KEY (id_val)
      REFERENCES val (id) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION,
  CONSTRAINT ck_reg_dvizh CHECK (fl =  1  OR fl = - 1 )
) 

-- Function: get_id_dvizh(nbuf integer)

-- DROP FUNCTION get_id_dvizh(nbuf integer);

CREATE OR REPLACE FUNCTION get_id_dvizh(nbuf integer)
  RETURNS bigint[] AS
$BODY$
DECLARE 			
	docid integer;    

BEGIN
INSERT INTO reg_dvizh(id_doc, str, fl, id_podr, id_tov, kol, sum, id_val, obj_doc) VALUES ( 28 ,  1 ,  1 ,  29 ,  28 ,  100 . 000 ,  1000 . 00 ,  29 , '');
return  23 ;		
--    return currval('reg_dvizh_id_seq');
 
	END;
$BODY$
  LANGUAGE 'plpgsql' VOLATILE;
ALTER FUNCTION get_id_dvizh(nbuf integer) OWNER TO pgadmin;