[SQL] Re: [SQL] Problema com função UPPER

2006-06-20 Thread Hélder M . Vieira
Eduardo, creio que o problema decorre do jogo de caracteres usado... No meu caso, uma vez que vivo em Portugal, uso o jogo LATIN9 quando crio uma nova base de dados. Simplificando: CREATE DATABASE xpto WITH OWNER = postgres ENCODING = 'LATIN9' TABLESPACE = pg_default; Hélder M.

Re: [SQL] unknown sqlstate code

2006-06-20 Thread Tom Lane
Juliann Meyer <[EMAIL PROTECTED]> writes: > I don't know if this is the correct list, but does any > one know what sqlstate code YE000 indicates? A quick look in the source code finds #define ECPG_SQLSTATE_ECPG_INTERNAL_ERROR "YE000" Probably a complete bug report is indicated.

[SQL] unknown sqlstate code

2006-06-20 Thread Juliann Meyer
I don't know if this is the correct list, but does any one know what sqlstate code YE000 indicates? I checked the Appendix of sqlstate codes for the version 7.4.8 that is being used and I don't see it on the list? All I can tell is it has something to do with the cursor that is trying to be opene

[SQL] Problema com função UPPER

2006-06-20 Thread Eduardo Giovany Schweigert
Pessoal estou com um problema para usar a função Upper, pelo que parece esta havendo uma incompatibilidade pois qd rodo o sql no linux ((Gentoo) funciona legal, agora no windows não ta trazendo os resultados. Em ambos os casos estou usando o Postgresql 8.1 com PgAdmin 1.4.1, o sql é o seguinte.sel

Re: [SQL] keeping last 30 entries of a log table

2006-06-20 Thread Jeff Frost
On Tue, 20 Jun 2006, Dirk Jagdmann wrote: Column id should be indexed indeed. Anyway, I'm not sure about any performance improvement using that last method, as the most consuming operation might be the DELETE operation, not really the SELECT operation, when dealing with a huge volume of data.

Re: [SQL] keeping last 30 entries of a log table

2006-06-20 Thread Dirk Jagdmann
Column id should be indexed indeed. Anyway, I'm not sure about any performance improvement using that last method, as the most consuming operation might be the DELETE operation, not really the SELECT operation, when dealing with a huge volume of data. why worry, there are a maximum of 30 Ent