Skip site navigation (1) Skip section navigation (2)

Bug Report

From: "Douglas M(dot) Westfall" <dougw(at)net(dot)kent(dot)edu>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug Report
Date: 2003-11-21 04:09:04
Message-ID: 1069387744.2491.1.camel@dw2 (view raw or flat)
Thread:
Lists: pgsql-bugs
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 pgsql-ports(at)postgresql(dot)org(dot)

To report any other bug, fill out the form below and e-mail it to
pgsql-bugs(at)postgresql(dot)org(dot)

If you not only found the problem but solved it and generated a patch
then e-mail it to pgsql-patches(at)postgresql(dot)org 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	:	dougw(at)net(dot)kent(dot)edu


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



Responses

pgsql-bugs by date

Next:From: Adrian CalvinDate: 2003-11-21 04:20:32
Subject: unsubscribe
Previous:From: Neil ConwayDate: 2003-11-21 02:09:47
Subject: Re: pg_dumpall does not save CREATE permission on databases

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group