Re: 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