never mind, it was the wrong type. sorry, > X-Original-To: [EMAIL PROTECTED] > Date: Thu, 16 Oct 2003 21:21:41 -0600 (MDT) > From: Kathy Zhu <[EMAIL PROTECTED]> > Subject: [GENERAL] pg_atoi > To: [EMAIL PROTECTED] > X-Virus-Scanned: by amavisd-new at postgresql.org > X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=BAYES_30, UPPERCASE_25_50 > X-Spam-Level: > X-Mailing-List: pgsql-general > > Hi, > > I got this message. Is that because the string id too long ?? > Where is the String length defined ?? > thanks, > Kathy > > insert into test (testid) > values('FAKEJOBMGRNAMEJOBNAME-020031016211324.144-06002elID--0jobname-0Thu Oct16 > 21:13:24 MDT 2003'); > > ERROR: pg_atoi: error in > "FAKEJOBMGRNAMEJOBNAME-020031016211324.144-06002elID--0jobname-0Thu Oct16 > 21:13:24 MDT 2003": can't parse > "FAKEJOBMGRNAMEJOBNAME-020031016211324.144-06002elID--0jobname-0Thu Oct16 > 21:13:24 MDT 2003" > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]