Re: [SQL] TEXT in select

2001-10-02 Thread Michael Remme
even the simple things can be that difficult :-) Best, Michael > -Ursprüngliche Nachricht- > Von: Haller Christoph [mailto:[EMAIL PROTECTED]] > Gesendet: Freitag, 28. September 2001 16:11 > An: Michael Remme > Cc: [EMAIL PROTECTED] > Betreff: Re: [SQL] TEXT in select > &

Re: [SQL] TEXT in select

2001-09-29 Thread Haller Christoph
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

[SQL] TEXT in select

2001-09-27 Thread Michael Remme
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 testt