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.
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
