Rod Taylor wrote: - Start of PGP signed section. > Below is a 7.2.4 example of the rserv log with inet data type. You will > notice that inet cast to text, and the log entry are differently (one > from unknown directly to text via a trigger, the other from inet cast to > text). > > I see this hasn't been changed in the 7.4 version. Is there intent on > removing this package entirely in favour of eRServer?
Yes, I think so. --------------------------------------------------------------------------- > > > build=# select _build2.ip::text, l.key, _build2.ip::text = l.key from > _RSERV_LOG_ l, build2 _build2 where l.reloid = 16734 and l.deleted = 0 > and (l.logid >= 513); > ip | key | ?column? > --------------------+-----------------+---------- > 123.123.123.123/32 | 123.123.123.123 | f > 123.123.123.122/32 | 123.123.123.123 | f > 123.123.123.123/32 | 123.123.123.122 | f > 123.123.123.122/32 | 123.123.123.122 | f > (4 rows) > -- End of PGP section, PGP failed! -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend