Received: from mail1.hub.org (webmail.hub.org [216.126.85.1]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f8T55OO63076 for ; Sat, 29 Sep 2001 01:05:24 -0400 (EDT) (envelope-from ch@rodos.fzk.de) Received: from resy5.fzk.de (resy5.fzk.de [141.52.68.8]) by mail1.hub.org (8.11.3/8.11.4) with ESMTP id f8SCBiS42285 for ; Fri, 28 Sep 2001 08:11:44 -0400 (EDT) (envelope-from ch@rodos.fzk.de) Received: by rodos.fzk.de with ESMTP (8.8.6 (PHNE_17135)/8.7.1) id OAA04233; Fri, 28 Sep 2001 14:12:33 +0200 (METDST) From: Haller Christoph Message-Id: <200109281211.OAA16242@rodos> Subject: Re: TEXT in select To: remme@java-beans.de (Michael Remme) Date: Fri, 28 Sep 2001 14:11:04 METDST Cc: pgsql-sql@postgresql.org In-Reply-To: <9opig1$1o1u$1@news.tht.net>; from "Michael Remme" at Sep 27, 101 6:51 pm X-Mailer: Elm [revision: 212.4] X-Archive-Number: 200109/270 X-Sequence-Number: 4952 I've tried (column indexdef is of type text) select indexdef from pg_indexes where indexdef like '%pg_proc%' ; select indexdef from pg_indexes where position('pg_proc' in indexdef) > 0 ; select upper(indexdef) from pg_indexes where position('pg_proc' in indexdef) > 0 ; and all three worked as intended. Sorry, but I can't see any reason why it doesn't work on your machine. Regards, Christoph > Hi, > > does anybody know a way, how to implement the content of a field of type > TEXT > into a query? > > if i am trying: > select * from testtable WHERE testTEXT LIKE '%testString%' > > i am getting always an empty selection, although there is a record existing. > The same with > > select * from testtable WHERE position ('testString' in testTEXT) > > 0; > > Additional, is there a way to use the UPPER()-function to the content of the > TEXT-field? > > Thanks in advance, > Michael