Re: string is sometimes null ?

On Wed, 29 Sep 2004, Graeme Hinchliffe wrote:

>     The RADIUS server is reporting problems when trying to write START of
> accounting entries, and the error given is:
>
> ERROR:  cannot EXECUTE a null querystring CONTEXT:  PL/pgSQL function
> "radacct_trig" line 43 at open
>
> The lines its refering to are:
>
> --- START ---
>
> str:=''SELECT
> username,year_of_jan,current_in,current_out,current_start,last_update,m''||monthcurr||''_in
> AS monthin,m''||monthcurr||''_out AS monthout
>   FROM customer_stats WHERE username=''''''||username||'''''''';

If monthcurr or username are null, the above will be null.
Anything || NULL => NULL.