| From: | Neil Conway <neilc(at)samurai(dot)com> |
|---|---|
| To: | Richard Huxton <dev(at)archonet(dot)com> |
| Cc: | Bjorn T Johansen <btj(at)havleik(dot)no>, PostgreSQL General <pgsql-general(at)postgresql(dot)org>, PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: [PERFORM] Seq scan of table? |
| Date: | 2003-09-05 18:20:18 |
| Message-ID: | 1062786017.447.1.camel@tokyo |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
On Fri, 2003-09-05 at 06:07, Richard Huxton wrote:
> PG's parser will assume an explicit number is an int4 - if you need an int8
> etc you'll need to cast it, yes.
Or enclose the integer literal in single quotes.
> You should find plenty of discussion of why in the archives, but the short
> reason is that PG's type structure is quite flexible which means it can't
> afford to make too many assumptions.
Well, it's definitely a bug in PG, it's "quite flexible" type structure
notwithstanding.
-Neil
| From | Date | Subject | |
|---|---|---|---|
| Next Message | CSN | 2003-09-05 18:45:56 | Re: Pagination - 1 or 2 queries? |
| Previous Message | Darko Prenosil | 2003-09-05 18:05:21 | Re: How can I set postmaster as a service |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-09-05 18:38:15 | Re: [GENERAL] how to get accurate values in pg_statistic (continued) |
| Previous Message | Relaxin | 2003-09-05 18:18:35 | Re: SELECT's take a long time compared to other DBMS |