On Thu, Oct 11, 2012 at 5:26 AM, Ondrej Ivanič <ondrej.ivanic@xxxxxxxxx> wrote:
Yes. Considering the storage requirements , I am looking for TINYINT kind of data type.
If I use "char" for numeric field, would it be possible to do numeric operations comparisons such as max(tint_unsigned) ?
--- Vineet
Hi,
What do you exactly mean? Do you care about storage requirements or
On 10 October 2012 19:47, Vineet Deodhar <vineet.deodhar@xxxxxxxxx> wrote:
> 3) Can I simulate MySQL's TINYINT data-type (using maybe the custom data
> type or something else)
constraints? The smallest numeric type in postgres is smallint: range
is +/- 32K and you need two bytes. You can use check constraint to
restrict the range (postgres doesn't have signed / unsigned types):
create table T (
tint_signed smallint check ( tint_signed >= -128 and tint_signed =< 127 ),
tint_unsigned smallint check ( tint_unsigned >= 0 and tint_unsigned =< 255 )
)
Yes. Considering the storage requirements , I am looking for TINYINT kind of data type.
if you care about storage then "char" (yes, with quotes) might be the
right type for you.
--
Ondrej Ivanic
(ondrej.ivanic@xxxxxxxxx)
(http://www.linkedin.com/in/ondrejivanic)
If I use "char" for numeric field, would it be possible to do numeric operations comparisons such as max(tint_unsigned) ?
--- Vineet