inet_aton in mysql, how to convert it to postresql?

Hi,
I need some help to solve a problem regarding transfer from mysql to postresql.
Previously in mysql, we use inet_aton such below:

select inet_aton(namatable.host) from ...

how can i do in postresql??

-azah

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Re: inet_aton in mysql, how to convert it to postresql?

> select inet_aton(namatable.host) from ...
>
> how can i do in postresql??

Try these:

http://www.postgresql.org/docs/7.4/static/functions-net.html

You need to be using the 'inet' or 'cidr' types.

Chris

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly