[PostgreSQL / plpgsql ]: How to use function parameter inside DECLARE block?

Question

CREATE OR REPLACE FUNCTION Test_Param_Insert_Data(p_schema_table text, p_dblinkcon text) RETURNS void AS $$
declare 
    rec p_schema_table;
BEGIN
....

How to use function parameter p_schema_table as composite_type_name e.g. rec public.customer.

I tested create function, but error return

ERROR: type "p_schema_table" does not exist

Why plpgsql language don't understand p_schema_table is passing function parameter, It's should treat to table name e.g public.customer

Tomasz Myrta · Accepted Answer · 2016-04-20 06:30:00Z

0

You can't declare variable, which type is passed as parameter. In such case you should declare it using RECORD type.

answered Apr 20, 2016 at 6:30

Tomasz Myrta

1,1449 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

autthapone Over a year ago

I already try to use RECORD type, but it does't work for me. I want to wildcard (*) all elements of rec e.g. INSERT INTO public.customer_test SELECT rec.*;

Collectives™ on Stack Overflow

[PostgreSQL / plpgsql ]: How to use function parameter inside DECLARE block?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related