Re: [ADMIN] postgres types

2000-05-08 Thread Peter Eisentraut
Bruce Momjian writes: > OID should be an unsigned int. Let us know if there are any problems. The oid type is for storing oids, not arbitrary numbers. It might happen to do that too, but it isn't designed for it. To get unsigned numbers use a check contraint. Then everyone knows what's going on

Re: [ADMIN] postgres types

2000-05-07 Thread Bruce Momjian
OID should be an unsigned int. Let us know if there are any problems. [Charset koi8-r unsupported, filtering to ASCII...] > > Hello all, > > Can I have UNSIGNED integer in PostgreSQL ? > E.g. how should I describe type of field to have > full range of 32 bits? If I describe filed as INT4, > I