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
>
&
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
