On 30/03/2004 20:25 Jaime Casanova wrote:
hi all,

i have an amd athlon with 256 ram (i know, this is not a *real* server but my tables are small)

i'm using vb6 (win98) with pgsql-7.3.4 (rh8) trough the psqlodbc.

when i do a select in took long to execute, here is an example

table icc_m_banco

      CodBanco             SMALLINT NOT NULL,
      Descripcion          CHARACTER VARYING(60) NOT NULL,
      RefContable          NUMERIC,
      Estado               CHAR(1) NOT NULL,
      FecRegistro          DATE NOT NULL,
      CONSTRAINT EstadoBanco CHECK ((Estado = 'A') or (Estado = 'I')),
      PRIMARY KEY(CodBanco)

select * from icc_m_banco where codbanco = 1;

select * from icc_m_banco where codbanco = 1::int2;

Paul Thomas
| Thomas Micro Systems Limited | Software Solutions for Business |
| Computer Consultants | http://www.thomas-micro-systems-ltd.co.uk |

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
     joining column's datatypes do not match

Reply via email to