| From: | Chris Picton <Chris(dot)Picton(at)usko(dot)com> |
|---|---|
| To: | Postgres mailing list <pgsql-general(at)postgresql(dot)org> |
| Subject: | bug? |
| Date: | 2000-11-10 10:55:04 |
| Message-ID: | 3A0BD408.48B8ACDA@usko.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi
I have the following two queries:
1) select count(*) from mappings where substring(virtual from 1 for 1) = '@';
2) select count(*) from mappings where virtual like '@%';
both should do the same thing - give me a count of virtual which starts with '@'.
however, the results returned are different
Statement 1 returns 12
Statement 2 returns 2623
Is there an error in my tables? If so, how would I fix it?
Regards
--
Chris Picton
Usko Communications Systems Developer
Chris(dot)Picton(at)usko(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Roger Wernersson | 2000-11-10 10:55:40 | Semaphores was: Increasing the number of semaphores on FreeBSD 4. 1 (clarification) |
| Previous Message | Radoslaw Stachowiak | 2000-11-10 10:43:20 | strange behvaviour in join? BUG in 7.02? |