Re: Arrays of Records in PL/Perl

On Jul 12, 2011, at 12:19 PM, Alex Hunsaker wrote:

> All Arrays in 9.0 and lower are strings, regardless of if they are
> comprised of composite types. Its not so much a bug as a limitation.
> Alexey Klyukin fixed this for 9.1 :-)

Oh?
              dump              --------------------------    $VAR1 = {               +              'that' => '5',+
         'this' => '3' +            };              +   (1 row)
 
   Time: 2.016 ms                           dump
----------------------------------------------------   $VAR1 = bless( {                                  +
      'array' => [                     +                                  {                   +
          'that' => '5',    +                                    'this' => '3'     +                                  }
                 +                                ],                    +                     'typeoid' => 16457
      +                   }, 'PostgreSQL::InServer::ARRAY' );+   (1 row)
 

Woo! Thanks!

> [ In 9.1 we could not make them straight perl arrayrefs as we needed
> to keep the string representation for backwards compatibility. What we
> did in 9.1 is overload the arrayref and string operations on blessed
> object so you can treat it as either. ]

Yep, awesome.

Best,

David