A. Kretschmer wrote:
> In response to Alexander Farber :
> > And identifiers means column names (eventually containing whitespace)?
>
> Right.
>
> test=# select 'foo' as "my new column";
> my new column
> ---------------
> foo
> (1 row)
And double-quotes preserve case:
test=> select 'foo' as Mine;
mine
------
foo
(1 row)
test=> select 'foo' as "Mine"; <-- double-quotes
Mine <--
------
foo
(1 row)
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ None of us is going to be here forever. +