From: | "Andrew Dunstan" <andrew(at)dunslane(dot)net> |
---|---|
To: | <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Anyone want to fix plperl for null array elements? |
Date: | 2005-11-18 03:44:47 |
Message-ID: | 2630.24.211.165.134.1132285487.squirrel@www.dunslane.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Tom Lane said:
> I think plperl should be fixed to translate undef to NULL when
> returning an array, but currently it translates to an empty string:
>
> pl_regression=# CREATE OR REPLACE function returns_array() returns
> text[] as $$ pl_regression$# return ['a,b','c"d',undef,'e-f']; $$
> LANGUAGE plperl; CREATE FUNCTION
> pl_regression=# select returns_array();
> returns_array
> -----------------------
> {"a,b","c\"d","",e-f}
> (1 row)
>
> There might be some problems going in the other direction, too;
> I haven't tried. Anybody feeling eager to fix this?
>
I will fix this tomorrow - it's about a 4 line fix. I've missed the details
- we're just using an unquoted NULL in array literals?
cheers
andrew
From | Date | Subject | |
---|---|---|---|
Next Message | Ferindo Middleton | 2005-11-18 03:54:36 | BUG #2052: Federal Agency Tech Hub Refuses to Accept Postgresql on Network because of Security Vulnerabilities |
Previous Message | Tom Lane | 2005-11-18 03:37:31 | Re: Anyone want to fix plperl for null array elements? |