Syntax error at or near "TYPE" in Postgresql

Question

Hi I was trying to create Type but getting a Syntax error while doing it.

CREATE OR REPLACE TYPE ARR_HNW_ID AS VARRAY(50) OF INTEGER;

Can you please help me to resolve this Issue

NickW · Accepted Answer · 2021-09-29 12:11:06Z

1

I don’t believe OR REPLACE is valid syntax. You can CREATE or ALTER types but not REPLACE

answered Sep 29, 2021 at 12:11

NickW

10k2 gold badges10 silver badges26 bronze badges

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

1 Comment

I have tried with CREATE TYPE ARR_HNW_ID AS VARRAY(50) OF INTEGER; Also but getting same error. Can you pls try ?

Julius Tuskenis · Accepted Answer · 2021-09-29 12:53:04Z

1

Thera are multiple mistakes in your SQL:

There is no CREATE OR REPLACE TYPE syntax in PostgreSQL- take a look into docs;
There is no type VARRAY in postgresql. If you need an array of integer just declare it like integer[].
What you are creating here is not a type but a DOMAIN.

So basically you can simply use integer[] for your ARR_HNW_ID

answered Sep 29, 2021 at 12:53

Julius Tuskenis

1,63010 silver badges15 bronze badges