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
