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