From: | "Michael Beckstette" <mbeckste(at)TechFak(dot)Uni-Bielefeld(dot)DE> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | length limitation in '=' operator when comparing TEXT fields ? |
Date: | 2002-05-23 19:23:55 |
Message-ID: | 1020523212355.ZM10386@sirari.TechFak.Uni-Bielefeld.DE |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hi,
i have a little problem when selecting entries from a table, specified by a
long match on a field of type TEXT. Is there a length limitation for the '='
operator when comparing a field of type TEXT to a given string ?
Example:
SELECT description FROM sequences_33 WHERE description LIKE 'gi 17559974%';
Result:
gi 17559974 ref NP_506864.1 (NM_074463) acid phosphatase [Caenorhabditis
elega
ns] gi 7499536 pir T21181 hypothetical protein F21A3.2 - Caenorhabditis
elegans
gi 3876155 emb CAB04153.1 (Z81509) predicted using Genefinder Similarity to
As
pergillus acid phosphatase (TR:Q12546) cDNA EST yk3g4.5 comes from this gene
cDN
A EST yk69f10.5 comes from this gene cDNA EST yk231b3.5 comes from this gene
cDN
A EST yk285e4.5 comes from this gene cDN
(1 row)
Thats ok. And now:
SELECT description FROM sequences_33 WHERE description=' gi 17559974 ref
NP_506864.1 (NM_074463) acid phosphatase [Caenorhabditis elega
ns] gi 7499536 pir T21181 hypothetical protein F21A3.2 - Caenorhabditis
elegans
gi 3876155 emb CAB04153.1 (Z81509) predicted using Genefinder Similarity to
As
pergillus acid phosphatase (TR:Q12546) cDNA EST yk3g4.5 comes from this gene
cDN
A EST yk69f10.5 comes from this gene cDNA EST yk231b3.5 comes from this gene
cDN
A EST yk285e4.5 comes from this gene cDN'
(0 row)
The two strings are identical and there are no confusing characters in them.
Any idea ?
PS: The type of field description is TEXT
Thanx in advance
Michael
-------------------------------------------------------------------------------
Dipl.-Inform. Michael Beckstette Office: M3-129
AG-PI / Technische Fakultaet EMail:mbeckste(at)techfak(dot)uni-bielefeld(dot)de
Universitaet Bielefeld Fon: +49-521-106-2914
Postfach 100131 Fax: +49-521-106-6411
D-33501 BIELEFELD
Germany
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-05-23 20:15:23 | Re: length limitation in '=' operator when comparing TEXT fields ? |
Previous Message | Jean-Luc Lachance | 2002-05-23 16:34:50 | Re: in(NULL) |