From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Pepe TD Vo <pepevo@yahoo.com>
To: Pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: %rowtype
Date: Fri, 09 Nov 2018 17:40:28 +0100
Message-ID: <384b702eb2c1ce3bfb40c290852fc461f9bd24fb.camel@cybertec.at> (raw)
In-Reply-To: <1072312432.1472810.1541769165531@mail.yahoo.com>
References: <1769600488.1326361.1541732091653.ref@mail.yahoo.com>
<1769600488.1326361.1541732091653@mail.yahoo.com>
<cca2ac7b8f6f19c5334d6aa803be33e1065bd7be.camel@cybertec.at>
<1072312432.1472810.1541769165531@mail.yahoo.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: laurenz.albe@cybertec.at, pepevo@yahoo.com
Subject: Re: %rowtype
In-Reply-To: <384b702eb2c1ce3bfb40c290852fc461f9bd24fb.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox