Received: from mail1.hub.org (webmail.hub.org [216.126.85.1]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f8T54tO62105 for ; Sat, 29 Sep 2001 01:04:55 -0400 (EDT) (envelope-from remme@java-beans.de) Received: from mout01.kundenserver.de (mout01.kundenserver.de [195.20.224.132]) by mail1.hub.org (8.11.3/8.11.4) with ESMTP id f8SEk7S47130 for ; Fri, 28 Sep 2001 10:46:07 -0400 (EDT) (envelope-from remme@java-beans.de) Received: from [195.20.224.220] (helo=mrvdom04.kundenserver.de) by mout01.kundenserver.de with esmtp (Exim 2.12 #2) id 15mytv-0007Yq-00; Fri, 28 Sep 2001 16:46:03 +0200 Received: from pd9e09d15.dip.t-dialin.net ([217.224.157.21] helo=braintags1) by mrvdom04.kundenserver.de with smtp (Exim 2.12 #2) id 15mytt-0006FQ-00; Fri, 28 Sep 2001 16:46:01 +0200 From: "Michael Remme" To: "Haller Christoph" Cc: Subject: Re: TEXT in select Date: Fri, 28 Sep 2001 16:46:47 +0200 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) In-Reply-To: <200109281211.OAA16242@rodos> X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 Importance: Normal X-Archive-Number: 200110/16 X-Sequence-Number: 4971 Yes, you are right. The error was, that i saved long text as part of a prepared statement by using the ascii-stream. Yesterday i recognized (at least), that i can save without any problem long text as part of a normal insert-string. And then the queries are working like they should. Sometimes even the simple things can be that difficult :-) Best, Michael > -----Ursprüngliche Nachricht----- > Von: Haller Christoph [mailto:ch@rodos.fzk.de] > Gesendet: Freitag, 28. September 2001 16:11 > An: Michael Remme > Cc: pgsql-sql@postgresql.org > Betreff: Re: [SQL] TEXT in select > > > 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 > > Virengeprüft vom G DATA AntiVirenKit