greetings all i want to know what's equivalent to Long data type in postgresql which i can retrieve in a long variable.
+1
A:
Should be a bigint
bigint 8 bytes large-range integer -9223372036854775808 to 9223372036854775807
From here: http://www.postgresql.org/docs/current/interactive/datatype-numeric.html
SQLMenace
2010-07-14 10:28:57
you are right but bigint cannot be casted to long, so what is the solution then ?
sword101
2010-07-14 10:53:10
@sword101: bigint in postgresql should be extracted from the ResultSet with the getLong() method- not getBigDecimal(). "bigint" isn't a java type, "long" isn't a postgresql type, so what you just said doesn't quite make sense.
araqnid
2010-07-14 22:22:45
i am using hibernate ?
sword101
2010-07-15 08:00:21