On 2009-08-09, Mindaugas G. <mindau...@biovela.lt> wrote: > Hi, > > googling few days with no success, > for example I have db with ip_src etc ant its data type bigint, > how must look select query what I can see ip address (int) instead of > bigint?
dunno if this will help. create function bigint_to_inet(bigint) returns inet as $$ select (($1>>24&255)||'.'||($1>>16&255)||'.'||($1>>8&255)||'.'||($1>>0&255))::inet $$ immutable language sql; -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
