[SQL] PostgreSQL - ERROR: Cannot cast type character varying to integer

Hello I´m new in the list, and I want to learn a lot about postgresql, now I´m working in a database and I have this problem: I have a table called historicoventas as follows (just the structure) > historicoventas > ( > codigopedidovarchar(20) > codigohospital

Re: [SQL] Clustering problem

Why would you then drop the index? Performance and storage issues? I imagine that I would cluster the table at regular intervals to maintain the ordering, so I'd need to to keep the index around, yes? --- PFC <[EMAIL PROTECTED]> wrote: > > > > Is it even possible to cluster a table based on th