next question, signed/unsigned

From: Andy Harrison <ah59(at)httpsite(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: next question, signed/unsigned
Date: 2003-04-09 18:43:59
Message-ID: XFMail.20030409144359.ah59@httpsite.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

I'm trying to do what I can to help the phpwebsite guys get their app working
with postgres. They're quite willing so I'm trying to do what legwork I can
for them.

Their script runs this during install:

CREATE TABLE cache ( mod_title varchar(30) NOT NULL default '', id varchar(32)
NOT NULL default '', data text NOT NULL, ttl int unsigned NOT NULL default
'0');

postgres doesn't like unsigned at all. I can't really find a reference to
unsigned integers related to creating columns in the docs, so does this even
apply? Should I just tell them to ignore it in postgres?

~~
Andy Harrison
ah##(at)httpsite(dot)com
ICQ: 123472 AIM/Y!: AHinMaine
[full headers for details]

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

iQCVAwUBPpRp7VPEkLgodAWVAQFnGAP+MkIXQGzJxEAkXeEncBSHXG0r65jhiruM
nj+z0L+fQUEcPPZV4UfUsZUMnGpqZRYnl+DdqHI85g2+BBrydQZFA83AxXRNDhvi
mZoVTR8ha/yPnvRsA5Jz86HlbhJbj6JuQ/lQup67VOmYbSsCrCFBaKA7YafcgoQ+
EvBeDi9chSA=
=MiSW
-----END PGP SIGNATURE-----

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Josh Berkus 2003-04-09 19:03:43 Re: next question, signed/unsigned
Previous Message Andy Harrison 2003-04-09 18:38:46 Re: namespace?