CREATE TYPE error in PostgreSQL database!!!!!!

From: Ashok Kumar Mani <ashokkumar(dot)mani(at)dnata(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: CREATE TYPE error in PostgreSQL database!!!!!!
Date: 2022-01-03 07:40:21
Message-ID: DXXP273MB006110F6833EAA25FA39D579F0499@DXXP273MB0061.AREP273.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Team
While creating function I have encountered the below error in PostgreSQL database.

I need to know how to use the array declaration in Type datatype in postgreSQL database. Could you please help or share some exmple to use it?

1. Need to create type
2. Declare array variable in type datatype.

ERROR: syntax error at or near "c_db_fieldvalues" LINE 113: ... fetch usage_cursor into c_db_fieldvalues c_db_field... ^ SQL state: 42601 Character: 9447

Thanks & Best Wishes,
Ashok

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Holger Jakobs 2022-01-03 15:05:42 Re: CREATE TYPE error in PostgreSQL database!!!!!!
Previous Message Matt Zinicola 2022-01-02 02:00:44 Re: Compilation of postgres 13.4+ source fails to find some of its own libraries