Re: %rowtype

Pepe TD Vo wrote:
> thank you Ms. Albe,

I am male, but never mind.

> I have tried that and still not working. It passed that error and then complained about the shema, cidr_staging does not exist and/or c1 (cursor) is not exist. when I take it out, it complained invalid type name for those below:
> v_Rec_Num cidr_staging.stg_i864.receipt_number%type;
> v_Dat_Ent cidr_staging.stg_i864.date_entered%type;
> v_Seq_Num cidr_staging.stg_i864.sequence_number%type;

Works fine for me:

CREATE TABLE laurenz.test(id integer);

DO $$DECLARE
t laurenz.test.id%TYPE;
BEGIN
t := 1;
END;$$;

You should probably share the rest of your code + the exact error messages
so we can spot the error.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com