Re: Changing Data Types - Mailing list pgsql-novice

From Mike Frost
Subject Re: Changing Data Types
Date
Msg-id DUB127-W553FA0F762F217A9CE09BF82540@phx.gbl
Whole thread Raw
In response to Re: Changing Data Types  (Thom Brown <thom@linux.com>)
List pgsql-novice
From: thom@linux.com
Date: Mon, 7 Sep 2015 11:38:59 +0100
Subject: Re: [NOVICE] Changing Data Types
To: m_frost2010@hotmail.com
CC: pgsql-novice@postgresql.org

On 7 September 2015 at 11:33, Mike Frost <m_frost2010@hotmail.com> wrote:
thanks man!

so the syntax in [fielname]::[datatype]?

(note that emails to these mailing lists should be in plain text and responses below rather than above)

Yes, the section on type casting explains how it works:
http://www.postgresql.org/docs/9.5/static/sql-expressions.html#SQL-SYNTAX-TYPE-CASTS

Thom

-------------------

Thanks guys!




pgsql-novice by date:

Previous
From: Thom Brown
Date:
Subject: Re: Changing Data Types
Next
From: Keith Fisher
Date:
Subject: PostgreSQL, JDBC and BObj