UPDATE id_counter SET @nRetVal = id_counter.id, id_counter.id = id_counter.id + 1

nRetVal = (select id from disp.id_counter);   
UPDATE disp.id_counter SET id = id + _interval ;

client1: begin;
client1: nRetVal = (select id from disp.id_counter);
client2: begin;
client2: nRetVal = (select id from disp.id_counter);   
client1: UPDATE disp.id_counter SET id = id + _interval ;
client2: UPDATE disp.id_counter SET id = id + _interval ;
client1: commit;
client2: commit;

SELECT * FROM (<<Your subselect returning record>>) CurSubselect

BEGIN;
SELECT MyFunction();
SELECT * FROM MyTable1;
SELECT * FROM MyTable2;
COMMIT;

CREATE TEMP TABLE ... ON COMMIT DROP;

SQLEXEC(nStatementHandle [, cSQLCommand [, cCursorName[, aCountInfo]]])

CREATE OR REPLACE FUNCTION test_out(INOUT par1 integer, INOUT par2 integer)
  RETURNS record AS
$BODY$begin
par1 := par1+1;
par2 := par2-1;
return;
end;$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;

Local lnPar1, lnPar2, lcCom
lnPar1    = 1
lnPar2    = 2
lcCom    = [{CALL test_out(?@lnPar1::int,?@lnPar2::int)}]
SQLExec(nStatementHandle,lcCom)

UPDATE weather SET temp_lo = temp_lo+1, temp_hi = temp_lo+15, prcp = DEFAULT
  WHERE city = 'San Francisco' AND date = '2003-07-03'
  RETURNING temp_lo, temp_hi, prcp;

insert into sdadd.email (email) values ('def');  
  select currval('sdadd.my_big_sequence'::regclass);

insert into sdadd.email (email) values ('def') returning id