[HACKERS] PL/Perl Returned Array

[David E. Wheeler]

Hackers,

Given this script on 9.1beta3:

    BEGIN;

    CREATE EXTENSION plperl;

    CREATE OR REPLACE FUNCTION wtf(
    ) RETURNS TEXT[] LANGUAGE plperl AS $$ return []; $$;

    SELECT wtf() = '{}'::TEXT[];

    ROLLBACK;

The output is:

    BEGIN
    CREATE EXTENSION
    CREATE FUNCTION
     ?column? 
    ----------
     f
    (1 row)

    ROLLBACK

Why is that? If I save the values to TEXT[] columns, they are still not the 
same. But if I pg_dump them and then load them up again, they *are* the same. 
The dump looks like this:

    CREATE TABLE gtf (
        have text[],
        want text[]
    );

    COPY gtf (have, want) FROM stdin;
    {}  {}
    \.


Is PL/Perl doing something funky under the hood to array values it returns on 
9.1?

Thanks,

David


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers