From: | "Richard Huxton" <dev(at)archonet(dot)com> |
---|---|
To: | "Amit Saxena" <amitsaxena178(at)rediffmail(dot)com> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | FW: arrays in oracle? |
Date: | 2001-05-28 12:34:41 |
Message-ID: | 002101c0e772$96056d80$1001a8c0@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
From: "Amit Saxena" <amitsaxena178(at)rediffmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Justin Clift | 2001-05-28 13:14:11 | CLISP ? |
Previous Message | Kapil Tilwani | 2001-05-28 11:26:37 |