Re: [SQL] combining columns in select

Поиск
Список
Период
Сортировка
От D'Arcy" "J.M." Cain
Тема Re: [SQL] combining columns in select
Дата
Msg-id m11XaFN-0000c2C@druid.net
обсуждение исходный текст
Ответ на Re: [SQL] combining columns in select  (Jens Glaser <jens@helena.jens.de>)
Ответы Re: [SQL] combining columns in select  (Herouth Maoz <herouth@oumail.openu.ac.il>)
Список pgsql-sql
Thus spake Jens Glaser
> On Sat, 2 Oct 1999, Doug Thistlethwaite wrote:
> >    select lname + ', ' + fname as NAME from table ...
> 
> I think this is a parser bug. I recall there is a simple workaround:
> 
> select (lname + ', ') + fname ... (use braces)

While you are correct in your solution, it isn't a parser bug.  It just
follows the spec.  There has been talk of allowing the first form as
an extension.

-- 
D'Arcy J.M. Cain <darcy@{druid|vex}.net>   |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 425 1212     (DoD#0082)    (eNTP)   |  what's for dinner.


В списке pgsql-sql по дате отправления:

Предыдущее
От: Jens Glaser
Дата:
Сообщение: Re: [SQL] combining columns in select
Следующее
От: raptor
Дата:
Сообщение: Re: [SQL] How about a postgreSQL cookbook?