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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to