Re: BUG #3943: ecpg doesn't like "inet" operator

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Arnaud" <arnaud(dot)desmier(at)free(dot)fr>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3943: ecpg doesn't like "inet" operator
Date: 2008-02-08 21:42:47
Message-ID: 6993.1202506967@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Arnaud" <arnaud(dot)desmier(at)free(dot)fr> writes:
> EXEC SQL SELECT text(inet :ip_address) INTO :ip_result;

This is incorrect, and always has been, but 8.3 is more picky about it.
Use a cast instead, eg

> EXEC SQL SELECT text(:ip_address :: inet) INTO :ip_result;

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2008-02-08 21:44:24 Re: BUG #3944: Unable to create a database using SQL_ASCII encoding
Previous Message Dan Hrabarchuk 2008-02-08 20:24:14 BUG #3944: Unable to create a database using SQL_ASCII encoding