Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 2953853F49 for ; Thu, 5 Jan 2012 15:14:55 -0400 (AST) Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Rism3-0006UB-Dv for pgsql-sql@postgresql.org; Thu, 05 Jan 2012 19:14:55 +0000 Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id q05JEccw004633; Thu, 5 Jan 2012 14:14:38 -0500 (EST) To: Carlos Mennens cc: "PostgreSQL (SQL)" Subject: Re: DECIMAL or NUMERIC Data Types In-reply-to: References: Comments: In-reply-to Carlos Mennens message dated "Thu, 05 Jan 2012 13:38:01 -0500" Date: Thu, 05 Jan 2012 14:14:37 -0500 Message-ID: <4632.1325790877@sss.pgh.pa.us> From: Tom Lane X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201201/25 X-Sequence-Number: 36196 Carlos Mennens writes: > Does it matter when writing SQL code in PostgreSQL if I use DECIMAL or > NUMERIC date types for a column named 'price' assuming it's to store > the associated items actual dollar amount? No, because they're the same type in Postgres, as you were already told last week: http://archives.postgresql.org/pgsql-general/2011-12/msg00899.php regards, tom lane