TEXT in selection?

From: "Michael Remme" <remme(at)java-beans(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: TEXT in selection?
Date: 2001-09-25 11:51:35
Message-ID: 9opr2j$1ph2$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Nicolas Milet 2001-09-25 12:12:01 PgSQL behind a firewall
Previous Message Christian Pomar Berry 2001-09-25 10:02:31 Clustering