Re: function returning array - Mailing list pgsql-sql

Joe Conway writes: 

>> dennis'#                 pParsed         varchar[];
> 
> Make that last line:
>                            pParsed         varchar[] := ''{}''; 
> 
> That initializes pParsed to an *empty* array. Otherwise pParsed is NULL, 
> and when you attempt to extend a NULL array, e.g. "pParsed[1] = ''blah''" 
> you still get NULL. 

Joe, thank you very much! It makes much sense now that you tell me, but it 
was obviously not something I thought of. 

Dennis
pg-user a t calico-consulting dot com