Postgres Pro
Downloads
Home   >   mailing lists

Changing Data Types - Mailing list pgsql-novice

From Mike Frost
Subject Changing Data Types
Date
Msg-id DUB127-W87C10541914BD1F768212582540@phx.gbl
Whole thread Raw
In response to Re: Trouble including pg_type.h  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Changing Data Types  (Thom Brown <thom@linux.com>)
List pgsql-novice
Tree view
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!

pgsql-novice by date:

Previous
From: Michael Wood
Date:
Subject: Re: Trouble including pg_type.h
Next
From: Thom Brown
Date:
Subject: Re: Changing Data Types