View Single Post

   
  #4 (permalink)  
Old 04-11-2008, 07:52 AM
Tom Lane
 
Posts: n/a
Default Re: Anyone want to fix plperl for null array elements?

"Andrew Dunstan" <andrew@dunslane.net> writes:
> 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?


Right. Case-insensitive, double-quote it if you want the literal string
instead.

regression=# select array[1,null,3];
array
------------
{1,NULL,3}
(1 row)


regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Reply With Quote