[syslog-ng]replacing plpgsql timestamp fn calls in 7.2

colm ennis colm.ennis@eircom.net
Mon, 2 Sep 2002 20:02:18 +0100


hi,

a plpgsql trigger i used in 7.1 made the following use of the
timestamp function:
	insert into syslog_table values (timestamp(new.sdate, new.stime), hostid,
ciscomsgid, new.smsg);

ive had to upgrade to 7.2 and i read in the release notes that this function
is gone in 7.2:
	The timestamp() function is no longer available. Use timestamp 'string'
instead, or CAST.

how do i get this insert to work? i have no idea of the syntax required.

thanks for your help,

colm ennis