Re: How to cast, if type has spaces in the name

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Bryce Nesbitt <bryce1(at)obviously(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: How to cast, if type has spaces in the name
Date: 2007-07-26 15:00:59
Message-ID: 20070726075708.M12817@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Thu, 26 Jul 2007, Bryce Nesbitt wrote:

> How do I specify a cast, if the type name has spaces? foo::integer is
> easy,
> but foo::'timestamp without time zone' is more murky.

foo::timestamp without time zone should work (no quotes). Another
alternative if you don't like the way that looks is to use the SQL cast
syntax, CAST(foo AS timestamp without time zone).

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Harald Armin Massa 2007-07-26 15:17:03 Re: Tunning PostgreSQL performance for views on Windows
Previous Message Bill Moran 2007-07-26 14:49:05 Re: Tunning PostgreSQL performance for views on Windows