Postgres Pro
Downloads
Home   >   mailing lists

problem casting varchar to inet - Mailing list pgsql-general

From Roman Neuhauser
Subject problem casting varchar to inet
Date
Msg-id 20050722122031.GA16687@isis.sigpipe.cz
Whole thread Raw
Responses Re: problem casting varchar to inet
List pgsql-general
Tree view 
select cast(coalesce(nullif('', trim(callingip)), '127.0.0.1') as inet)

ERROR:  invalid input syntax for type inet: ""

    what is it trying to tell me?

--
How many Vietnam vets does it take to screw in a light bulb?
You don't know, man.  You don't KNOW.
Cause you weren't THERE.             http://bash.org/?255991

pgsql-general by date:

Previous
From: Roman Neuhauser
Date:
Subject: Re: Insert into ... Select ... From ... too intelligent transaction
Next
From: Michael Fuhr
Date:
Subject: Re: problem casting varchar to inet