Re: [Phpwebsite-developers] postgres

[Andy H. <ah...@ht...>]

-----BEGIN PGP SIGNED MESSAGE-----


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
On 10-Apr-2003, Matthew McNaney wrote message "Re: [Phpwebsite-developers]
postgres"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> I believe we can accommodate this, however, we would be losing half the
> range of an integer field. If an integer is not declared as unsigned, it
> assumes you will need negative numbers. So half the memory space is
> reserved for it. Correct me if I am wrong.
> 
> Should this be something to worry about for primary indecies? Do we need
> to find out how every DB handles > 0 numbers only?


Yeah, I wondered about that myself.  But when you use int, the docs say it
assumes int4 which is +/-2,000,000 so you should be all set.


> <rant> And what the hell good is a standard if every db does something
> different? </rant>

Geez, tell me about it.  Now that I'm digging in a little more, these syntax
differences are suprising.



~~ 
Andy Harrison
ah##@httpsite.com
ICQ: 123472  AIM/Y!: AHinMaine
[full headers for details]

-----BEGIN PGP SIGNATURE-----
Version: PGP 6.5.8

iQCVAwUBPpV0FVPEkLgodAWVAQHKJwP/fl8Em5t839ruGfp0moaC5bx9r3OVW7YE
BTFY8LtBXIXJFJEZh3WXJCUHuuU0/KbuUKM/H98SWQEH10vfF1Mo2uGyFqQDe8av
XS/JZGojhG91EvMw55RlnpNaVVE401tSgyFwOWHW5+y3MU9Uxokn2hBKIyIvv2d6
AUniQYCArRA=
=Fj5L
-----END PGP SIGNATURE-----