Postgres Pro
Downloads
Home   >   mailing lists

How best to create and use associative array type in Postgres? - Mailing list pgsql-general

From Shaozhong SHI
Subject How best to create and use associative array type in Postgres?
Date
Msg-id CA+i5JwYkKoQzWBfrkCLKo7PM-bPrb7cy7jz0W74XHVmCkePqGw@mail.gmail.com
Whole thread Raw
Responses Re: How best to create and use associative array type in Postgres?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
In Oracle, one can create and use associative array.  For instance,
TYPE FID_MEASURE IS TABLE OF NUMBER INDEX BY VARCHAR2(38);
NODES_WAITING FID_SET;

How best to create and use associative array type in Postgres?

Or, what is the best/most efficient equivalent in Postgres?

Regards,

David

pgsql-general by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: Can we use sql language to create a function in Postgres?
Next
From: Shaozhong SHI
Date:
Subject: Create and access a dictionary type