How make it work this Query un Postgres
lazarus / 16-Databases

----------------------------------------------------------------------
cpalx · 2018-04-09 03:52

i tried with PQconection
SQLquery
SQLtransaction

with any combination
(open, ExecSQL, Active:= true)
 (Transaction.commit, Transaction.commitRetain) 

Any Help? (i can not change The Query)

Code: MySQL  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i DO
$$ DECLARE mainid INTEGER; BEGIN  INSERT INTO job (name ,compid )
 VALUES ('Chofer ','1 ' ) RETURNING jobid INTO mainid; END$$;

----------------------------------------------------------------------
fpcoder · 2018-04-09 05:44

Have you checked this:
http://wiki.lazarus.freepascal.org/postgres#How_To

----------------------------------------------------------------------
goodname · 2018-04-09 11:50

You should look up PostgreSQL functions.

https://wiki.postgresql.org/wiki/FAQ#Does_PostgreSQL_have_stored_proce
dures.3F