TEXT in select - Mailing list pgsql-sql

From Michael Remme
Subject TEXT in select
Date
Msg-id 9opig1$1o1u$1@news.tht.net
Whole thread Raw
Responses Re: TEXT in select
List pgsql-sql
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







pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: HP-UX 11.0 postgres compile error!
Next
From: "meghana mande"
Date:
Subject: Problem in connection using .odbc.ini