| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | "Ryan" <pgsql-performance(at)seahat(dot)com> |
| Cc: | <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: How are null's stored? |
| Date: | 2003-05-12 22:46:39 |
| Message-ID: | 200305121546.39544.josh@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-performance |
Ryan,
> So if the internal format is identical, why does the INFERNAL database
> ignore indexes when you have a text compared to a varchar?
I don't seem to have this problem; I use TEXT or VARCHAR willy-nilly,
including in LIKE 'string%' and UPPER(field) queries, and the indexes work
fine.
I suspect that either you're talking about TEXT to CHAR(x) comparisons, which
are a different ball o' wax, or your query problem is something else.
--
-Josh Berkus
Aglio Database Solutions
San Francisco
| From | Date | Subject | |
|---|---|---|---|
| Next Message | scott.marlowe | 2003-05-12 22:56:02 | Re: Scheduled jobs |
| Previous Message | Nigel J. Andrews | 2003-05-12 22:38:59 | Re: Scheduled jobs |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2003-05-12 23:19:25 | Re: How are null's stored? |
| Previous Message | Andrew Sullivan | 2003-05-12 21:04:24 | Re: How are null's stored? |