INSERTING "NEW LINES" IN A SELECT STATEMENT

From: JORGE MALDONADO <jorgemal1960(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: INSERTING "NEW LINES" IN A SELECT STATEMENT
Date: 2009-05-14 19:03:20
Message-ID: f03943a00905141203r621404ceje3ccb32013317e5f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Ognjen Blagojevic 2009-05-14 19:21:47 Re: Unexpected behaviour of ORDER BY and LIMIT/OFFSET
Previous Message Tom Lane 2009-05-14 18:50:40 Re: Unexpected behaviour of ORDER BY and LIMIT/OFFSET