# [EMAIL PROTECTED] / 2005-07-22 06:50:58 -0600:
> On Fri, Jul 22, 2005 at 02:20:31PM +0200, Roman Neuhauser wrote:
> >
> > 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?
>
>
On Fri, Jul 22, 2005 at 02:20:31PM +0200, Roman Neuhauser wrote:
>
> 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?
NULLIF returns the first argument if the arguments aren't equal,
s
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. htt
