Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 8484F476A63 for ; Wed, 13 Mar 2002 17:10:59 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id g2DMAtS11653; Wed, 13 Mar 2002 17:10:55 -0500 (EST) To: "Graham Vickrage" Cc: "Postgres SQL" Subject: Re: Casting In-reply-to: References: Comments: In-reply-to "Graham Vickrage" message dated "Wed, 13 Mar 2002 17:41:24 +0000" Date: Wed, 13 Mar 2002 17:10:55 -0500 Message-ID: <11650.1016057455@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200203/173 X-Sequence-Number: 7053 "Graham Vickrage" writes: > I essentially need the last four digits of the number (securing > credit card numbers is the idea), which I can only do by manipulating text > and casting it back. What's wrong with a modulo operation? regression=# select '123456789'::int8 % 10000::int8; ?column? ---------- 6789 (1 row) regards, tom lane