Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Thu, 26 Jul 2007 08:00:59 -0700 (PDT)
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).
- References:
- How to cast, if type has spaces in the name
- From: Bryce Nesbitt
- How to cast, if type has spaces in the name
- Prev by Date: Tunning PostgreSQL performance for views on Windows
- Next by Date: unique index on fields with possible null values
- Previous by thread: Re: How to cast, if type has spaces in the name
- Next by thread: Tunning PostgreSQL performance for views on Windows
- Indexes: