> I tried this function but it keeps returning an error such as:
> 
> ERROR: invalid input syntax for integer: "2007-05-05 00:34:08"
> SQL state: 22P02
> Context: PL/pgSQL function "lagfunc" line 10 at assignment

Whoops, this line:

> >             client_id := thisrow.datetime;

Should be:

client_id := thisrow.client_id;



---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to