On 7 September 2015 at 11:33, Mike Frost <m_frost2010(at)hotmail(dot)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