INSERTING "NEW LINES" IN A SELECT STATEMENT

Поиск
Список
Период
Сортировка
От JORGE MALDONADO
Тема INSERTING "NEW LINES" IN A SELECT STATEMENT
Дата
Msg-id f03943a00905141203r621404ceje3ccb32013317e5f@mail.gmail.com
обсуждение исходный текст
Ответы Re: INSERTING "NEW LINES" IN A SELECT STATEMENT  (Ognjen Blagojevic <ognjen@etf.bg.ac.yu>)
Список pgsql-novice
I have a query like this:
 
SELECT field1 || field2 AS finalfield FROM table1
 
Is it possible to insert a new line between "field1" and "field2" (carriage return, line feed or something) so when "finalfield" is displayed it is shown in 2 lines?
 
My web application actually displays one line as follows depending on the internet browser:
1. The line displayed is "cut" so part of the information is not seen.
2. All of the information is displayed but the horizontal scrolling bar appears to "move the screen" to the right and read the complete information.
 
With respect,
Jorge Maldonado

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Unexpected behaviour of ORDER BY and LIMIT/OFFSET
Следующее
От: Ognjen Blagojevic
Дата:
Сообщение: Re: Unexpected behaviour of ORDER BY and LIMIT/OFFSET