pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: TEXT in select
3+ messages / 2 participants
[nested] [flat]

* Re: TEXT in select
@ 1970-01-01 00:00  Haller Christoph <ch@rodos.fzk.de>
  parent: Michael Remme <remme@java-beans.de>
  0 siblings, 1 reply; 3+ messages in thread

From: Haller Christoph @ 1970-01-01 00:00 UTC (permalink / raw)
  To: remme@java-beans.de; +Cc: pgsql-sql

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




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* TEXT in select
@ 2001-09-25 09:25  Michael Remme <remme@java-beans.de>
  0 siblings, 1 reply; 3+ messages in thread

From: Michael Remme @ 2001-09-25 09:25 UTC (permalink / raw)
  To: 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








^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: TEXT in select
@ 2001-09-28 14:46  Michael Remme <remme@java-beans.de>
  parent: Haller Christoph <ch@rodos.fzk.de>
  0 siblings, 0 replies; 3+ messages in thread

From: Michael Remme @ 2001-09-28 14:46 UTC (permalink / raw)
  To: Haller Christoph <ch@rodos.fzk.de>; +Cc: pgsql-sql

Yes, you are right. The error was, that i saved long text as part of a
prepared statement by using the ascii-stream. Yesterday i recognized (at
least), that i can save without any problem long text as part of a normal
insert-string. And then the queries are working like they should.

Sometimes even the simple things can be that difficult :-)

Best, Michael

> -----Ursprüngliche Nachricht-----
> Von: Haller Christoph [mailto:ch@rodos.fzk.de]
> Gesendet: Freitag, 28. September 2001 16:11
> An: Michael Remme
> Cc: pgsql-sql@postgresql.org
> 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 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
>
>

Virengeprüft vom G DATA AntiVirenKit




^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2001-09-28 14:46 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-09-25 09:25 TEXT in select Michael Remme <remme@java-beans.de>
1970-01-01 00:00 ` Haller Christoph <ch@rodos.fzk.de>
2001-09-28 14:46   ` Michael Remme <remme@java-beans.de>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox