Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group