I have three tables and I want to insert data into that three tables as per their respective data.
with acupressure_point_data as ( insert into acupressure_point(id, url) values('LL909', 'ww/33/11') returning id as acupressure_point_id ), acupressure_sub_type as ( insert into acupressure_point_region_sub_type (acupressure_point_id, region_sub_type_id) values(acupressure_point_id , '9898') returning id as acupressure_sub_type_id );
But it gives the error as:
"ERROR: syntax error at end of input Position"
I can not understood this. Please help me. Thanks