Postgres Pro
Downloads
Home   >   mailing lists

Re: How to cast, if type has spaces in the name - Mailing list pgsql-sql

From Stephan Szabo
Subject Re: How to cast, if type has spaces in the name
Date
Msg-id 20070726075708.M12817@megazone.bigpanda.com
Whole thread Raw
In response to How to cast, if type has spaces in the name  (Bryce Nesbitt <bryce1@obviously.com>)
List pgsql-sql
Tree view 
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).

pgsql-sql by date:

Previous
From: Ranieri Mazili
Date:
Subject: Tunning PostgreSQL performance for views on Windows
Next
From: Dmitry Ruban
Date:
Subject: unique index on fields with possible null values