Changing Data Types

From: Mike Frost <m_frost2010(at)hotmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Changing Data Types
Date: 2015-09-07 10:20:42
Message-ID: DUB127-W87C10541914BD1F768212582540@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi All,
This REALLY is a novice question
I'm writing a simple query where i need to return [Field A]/[Field B] so i can express [Field A] as a percentage
Both of these fields are BigInts, so i always get 0
What do i need to do to the data types in my query to enable decimal places?
Thanks!

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Thom Brown 2015-09-07 10:27:46 Re: Changing Data Types
Previous Message Michael Wood 2015-09-05 16:29:34 Re: Trouble including pg_type.h