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@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + None of us is going to be here forever. + -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
