Title: Re: [GENERAL] regarding threads and transactions - problem 2
patient_key is the unique
key
and the primary key is patient_id, which is
a bigserial.
actually this is what the stored procedure
does:
a patient comes and it is associated with
patient_key ...if is not present in
Surabhi Ahuja wrote:
BEGIN
patKey := $4;
select patient_id into patId from patient where patient_key = patKey;
if not found
THEN
insert into
patient(patient_name,org_pat_id,birth_date,patient_key)
values($1,trim($2),$3,$4);
The output that i a
On Fri, Aug 26, 2005 at 01:28:51PM +0530, Surabhi Ahuja wrote:
> Dear All,
>
> This is in reference to a problem which I had put up sometime back.
> Please take some time to study it
>
> The piece of code that i am trying to execute is attached (itsa cpp file)
> The stored procedure (that the
Dear All, This is in reference to a problem which I had put up
sometime back.
Please take some time to study it
The piece of code that i am trying to execute is
attached (itsa cpp file)
The stored procedure (that the program calls)
insert_patient is as follows:
CREATE OR REPLACE FUNCTION ins
