Re: Oracle to PostgreSQL

From: "Felix Kunde" <felix-kunde(at)gmx(dot)de>
To: "Laurenz Albe" <laurenz(dot)albe(at)cybertec(dot)at>
Cc: "Brahmam Eswar" <brahmam1234(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Oracle to PostgreSQL
Date: 2017-11-09 12:16:58
Message-ID: trinity-48025eba-14c5-46b8-bd16-85f8514d3f94-1510229818676@3c-app-gmx-bs72
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 2017-11-09 at 17:01 +0530, Brahmam Eswar wrote:
> You can create a composite type in PostgreSQL:
> CREATE TYPE complex AS (r integer, i integer);
> You would use an array in this case:
> DECLARE
> carr complex[];

I've once faced the same thing, and did as Laurenz suggested.
You will like Postgres' array support.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adam Brusselback 2017-11-09 14:22:16 Re: Migrating money column from MS SQL Server to Postgres
Previous Message Laurenz Albe 2017-11-09 11:40:54 Re: Oracle to PostgreSQL