FW: arrays in oracle?

From: "Amit Saxena" <amitsaxena178@rediffmail.com>

> Hi Richard!
>
> I have got ur mail ID from postgresql site.

Fair enough - techdocs.postgresql.org I suppose?

> I am facing one problem in porting Oracle  8.0 database function to
Postgresql.
>
> The statement is
> "Type t is table of varchar2(100) index by binary_integer;"
> This is used to create collection or say data type
> which act like array of variable length.

I'm afraid I don't use Oracle - although I do know there are several
articles at techdocs.postgresql.org (I'm guessing you have already read
these).

Have you looked at chapter 6 of the Users's Guide, which covers PostgreSQL
arrays? I don't know if they match Oracle's features.

> I am using postgres 7.0 on SUSE.

Perhaps think about upgrading to 7.1.x (7.1.2 is current I believe)

I've forwarded this to the pgsql-general mailing list - there are people
there who know Oracle well. If you aren't subscribed, you can do so or check
the archives from the www.postgresql.org website.

HTH

- Richard Huxton