Postgres Pro
Downloads
Home   >   mailing lists

Re: Anyone want to fix plperl for null array elements? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Anyone want to fix plperl for null array elements?
Date
Msg-id 1842.1132285051@sss.pgh.pa.us
Whole thread Raw
In response to Re: Anyone want to fix plperl for null array elements?  ("Andrew Dunstan" <andrew@dunslane.net>)
List pgsql-hackers
Tree view 
"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

pgsql-hackers by date:

Previous
From: "Andrew Dunstan"
Date:
Subject: Re: Anyone want to fix plperl for null array elements?
Next
From: "Jonah H. Harris"
Date:
Subject: Re: CLUSTER and clustered indices