Pavel Stehule wrote:
On Wed, 29 Jun 2005, Josh Berkus wrote:
Pavel,
The concept is from Oracle 9i, but with some changes.
http://www.oracle-10g.de/oracle_10g_documentation/appdev.101/b10807/05_coll
s.htm#i35672
How does this match the SQL2003 spec?
I don't know. What I can read about it, it's only PL/SQL feature and maybe
reason for PL/pgSQL.
I like and need
a) hash arrays
b) iteration over all items of array
All I can use well in my codes.
Well, plperl and pltcl will buy you these (not to mention plruby and
even pljavascript when I get around to creating it)
That's not to say that we should not build them into plpgsql, but to
suggest that there might be reasonable alternatives.
cheers
andrew
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend