From: Michael Remme <remme@java-beans.de>
To: pgsql-sql@postgresql.org
Subject: TEXT in select
Date: Tue, 25 Sep 2001 11:25:09 +0200
Message-ID: <9opig1$1o1u$1@news.tht.net> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: remme@java-beans.de
Subject: Re: TEXT in select
In-Reply-To: <9opig1$1o1u$1@news.tht.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox