On Tue, May 21, 2002 at 10:12:20AM -0400, Tom Lane wrote: > [EMAIL PROTECTED] writes: > > But the /y portion is shown in this case: > > pmoanalysis=> select ipaddress||'a' from dhcpservers; > > ?column? > > ------------- > > 1.2.3.4/32a > > (1 row) > > This implicitly coerces the inet value to text datatype, and the > text(inet) function always displays netmask. Perhaps you'd prefer > to use host() or abbrev() to do the conversion to text.
I've already changed it to use host(), was just a message to let you know that it might not have been working the way you expected it to do. Thanks for your reply and the database, it rocks :-) Edwin -- Edwin Groothuis | Personal website: http://www.MavEtJu.org [EMAIL PROTECTED] | Interested in MUDs? Visit Fatal Dimensions: bash$ :(){ :|:&};: | http://www.FatalDimensions.org/ ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
