Leandro, Estava sem resposta pois vc me disse uma coisa e o joão.junior outra. Verificando a documentação oficial 8.3.3 segundo segue abaixo:
"8.1.1. Integer Types The types smallint, integer, and bigint store whole numbers, that is, numbers without fractional components, of various ranges. Attempts to store values outside of the allowed range will result in an error. The type integer is the usual choice, as it offers the best balance between range, storage size, and performance. The smallint type is generally only used if disk space is at a premium. The bigint type should only be used if the integer range is not sufficient, because the latter is definitely faster. The bigint type might not function correctly on all platforms, since it relies on compiler support for eight-byte integers. On a machine without such support, bigint acts the same as integer (but still takes up eight bytes of storage). However, we are not aware of any reasonable platform where this is actually the case. SQL only specifies the integer types integer (or int), smallint, and bigint. The type names int2, int4, and int8 are extensions, which are shared with various other SQL database systems." A mesma não tem nota. Irei testar e postar... Obrigado! 2008/7/2 Leandro DUTRA <[EMAIL PROTECTED]>: > 2008/7/2 junior Prado <[EMAIL PROTECTED]>: > > Segundo no guia de usuário do postgresSQL 7.3.4 conforme abaixo: > > Se a nota está apenas no manual do 7, duvido que o 8 tenha o mesmo > comportamento — até porque esse é o tipo de coisa que está mais para > defeito que para característica. > > Que tal testar? > > -- > skype:leandro.gfc.dutra?chat Yahoo!: ymsgr:sendIM?lgcdutra > +55 (11) 3040 7300 r155 gTalk: xmpp:[EMAIL PROTECTED]<[EMAIL PROTECTED]> > +55 (11) 9406 7191 ICQ/AIM: aim:GoIM?screenname=61287803 > +55 (11) 5685 2219 MSN: msnim:[EMAIL PROTECTED] > _______________________________________________ > pgbr-geral mailing list > [email protected] > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral > -- VALTER CEZAR PRADO JUNIOR GRADUADO EM CIÊNCIA DA COMPUTAÇÃO - UFOP ANALISTA DE SISTEMAS - BYSAT DBA / PROJETISTA DE SISTEMAS - PBH Sem saber como fazer ele fez!
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
