how to remove ?
От | Subhramanya Shiva |
---|---|
Тема | how to remove ? |
Дата | |
Msg-id | 1032.192.168.0.2.989772239.squirrel@mail.archeanit.net обсуждение исходный текст |
Ответ на | Re: Problem using IP functions (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: how to remove ?
|
Список | pgsql-sql |
How to remove from this mailing list ? > "Marc Lamothe" <mlamothe@openface.ca> writes: > > The subnet_number column is a varchar(16) which I assume you can compare > > with a text data type, which is what host() returns. > > Are you on a pre-7.1 Postgres release? host() is buggy before 7.1 --- > it includes a trailing null in its output, which it shouldn't oughta > have done. You can't see the null from outside the system, but it > manages to mess up text comparisons anyway. > > BTW, you should consider using inet or cidr datatype for that column > rather than varchar... > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > -- Subhramanya Shiva, Programmer Archean InfoTech pvt.Ltd. Hyderabad, India http://www.archeanit.com
В списке pgsql-sql по дате отправления: