[sqlalchemy] Re: Tipo Money con Postgres
Hola a todos... Estoy intentando utilizar en una bd postgres el tipo Money, debido a que estoy haciendo una migracion de una bd vieja y necesito mantener ese tipo de datos. Pero veo que SQLAlchemy no lo posee, y no esta definido como tipo nativo de Postgres. Entonces, cual seria la mejor forma de usarlo? Creando un nuevo tipo de datos? Como seria eso? Si no me he expresado bien, me avisan y reformulo mi consulta. Cualquier ayuda que reciba, desde ya la agradezco Maybe is better you answer in English, however I will answer you in Portuguese. Eu estou utilizando Numeric(18,4) creio que deva ser este o tipo interno utilizado no money, eu mesmo iria pesquisar ou perguntar aqui no grupo a respeito disso. --- May someone have a best solution to postgresql Money datatype? or I need to use Numeric? thank's -- Alexandre da Silva Analista de Sistemas - Bacharel em Sistemas de Informação (2003-2007) --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~--~~~~--~~--~--~---
[sqlalchemy] Re: Tipo Money con Postgres
Em Qui, 2008-01-17 às 10:40 -0800, Marcos escreveu: Thank's Alexandre for the tip, but in my first and only one answer, y received a pair of solutions in spanish, so I tried first to ask in my language. As you can see, I'm not very good writing in english. But you are right. I will try to ask in this language from now. And thanks for the solution. That's works for me. ( E graças pela solução, isso funcionou para mim ) -- I used a translator for that : ) Marcos Alcázar No problems, my English is very bad too, because it's not my fist language and I learn more from internet and working with it. about your question, I think numeric will work for you. more one tip, I've found at postgresql documentation this note: Note: The money type is deprecated. Use numeric or decimal instead, in combination with the to_char function. from 7.3 to 8.2... and maybe others in http://www.postgresql.org/docs/7.3/interactive/datatype-money.html and http://www.postgresql.org/docs/8.2/interactive/datatype-money.html I suggest, if you can, change the datatype in next versions of your software. Att, -- Alexandre da Silva Analista de Sistemas - Bacharel em Sistemas de Informação (2003-2007) --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~--~~~~--~~--~--~---
[sqlalchemy] Re: Tipo Money con Postgres
Thank's Alexandre for the tip, but in my first and only one answer, y received a pair of solutions in spanish, so I tried first to ask in my language. As you can see, I'm not very good writing in english. But you are right. I will try to ask in this language from now. And thanks for the solution. That's works for me. ( E graças pela solução, isso funcionou para mim ) -- I used a translator for that : ) Marcos Alcázar On 17 ene, 15:49, Alexandre da Silva [EMAIL PROTECTED] wrote: Hola a todos... Estoy intentando utilizar en una bd postgres el tipo Money, debido a que estoy haciendo una migracion de una bd vieja y necesito mantener ese tipo de datos. Pero veo que SQLAlchemy no lo posee, y no esta definido como tipo nativo de Postgres. Entonces, cual seria la mejor forma de usarlo? Creando un nuevo tipo de datos? Como seria eso? Si no me he expresado bien, me avisan y reformulo mi consulta. Cualquier ayuda que reciba, desde ya la agradezco Maybe is better you answer in English, however I will answer you in Portuguese. Eu estou utilizando Numeric(18,4) creio que deva ser este o tipo interno utilizado no money, eu mesmo iria pesquisar ou perguntar aqui no grupo a respeito disso. --- May someone have a best solution to postgresql Money datatype? or I need to use Numeric? thank's -- Alexandre da Silva Analista de Sistemas - Bacharel em Sistemas de Informação (2003-2007) --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~--~~~~--~~--~--~---