pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: TEXT in select
3+ messages / 2 participants
[nested] [flat]
* TEXT in select
@ 2001-09-25 09:25 Michael Remme <remme@java-beans.de>
1970-01-01 00:00 ` Re: TEXT in select Haller Christoph <ch@rodos.fzk.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-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 ` Re: TEXT in select 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
* Re: TEXT in select
2001-09-25 09:25 TEXT in select Michael Remme <remme@java-beans.de>
1970-01-01 00:00 ` Re: TEXT in select Haller Christoph <ch@rodos.fzk.de>
@ 2001-09-28 14:46 ` Michael Remme <remme@java-beans.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