Yes, I have searched the archives, and searches for 'inet' or 'ilike' or 'inet+ilike' and 'inet&ilike' return 0 results each.
Have I missed something? Regards, DougW On Thu, 2003-11-20 at 23:09, Douglas M. Westfall wrote: > If PostgreSQL failed to compile on your computer or you found a bug that > is likely to be specific to one platform then please fill out this form > and e-mail it to [EMAIL PROTECTED] > > To report any other bug, fill out the form below and e-mail it to > [EMAIL PROTECTED] > > If you not only found the problem but solved it and generated a patch > then e-mail it to [EMAIL PROTECTED] instead. Please use the > command "diff -c" to generate the patch. > > You may also enter a bug report at http://www.postgresql.org/ instead of > e-mail-ing this form. > > ============================================================================ > POSTGRESQL BUG REPORT TEMPLATE > ============================================================================ > > > Your name : Douglas M. Westfall > Your email address : [EMAIL PROTECTED] > > > System Configuration > --------------------- > Architecture (example: Intel Pentium) : Intel P4 Itanium 2.4 > > Operating System (example: Linux 2.0.26 ELF) : Linux > 2.4.22-1.2087.nptlsmp #1 SMP i686 i686 i386 GNU/Linux (RH9+) > > PostgreSQL version (example: PostgreSQL-7.3.4): PostgreSQL-7.3.4 > > Compiler used (example: gcc 2.95.2) : RH9 using Ximian RUG > rpm's ... > update of 19 Nov 2003 > > > Please enter a FULL description of your problem: > ------------------------------------------------ > 1) table contains a valid inet field > 2) query works fine in pgsql 7.2 & 7.3 > 3) query no longer works in pgsql 7.4 > > select * from <table> where <field> ilike '%<inetvalue>%' ; > > fails with: > ERROR: Unable to identify an operator '~~*' for types 'inet' and > '"unknown"' > You will have to retype this query using an explicit cast > > > Please describe a way to repeat the problem. Please try to provide a > concise reproducible example, if at all possible: > ---------------------------------------------------------------------- > > select * from ipaddrs2 where ip2_address ilike '%10.123.252.4%' order by > ip2_address asc; > > CASTing the operator provides no resolution, as it causes syntax errors, > ie: > select * from ipaddrs2 where ip2_address ilike '%10.123.252.4%'::inet > order by ip2_address asc; > returns: > ERROR: invalid INET value '%10.123.252.4%' > AND: > select * from ipaddrs2 where ip2_address ilike CAST('%10.123.252.4% as > inet) order by ip2_address asc; > returns: > ERROR: invalid INET value '%10.123.252.4%' > > If you know how this problem might be fixed, list the solution below: > --------------------------------------------------------------------- > > Apparent problem in ilike function dealing with inet values > > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html