Postgres Pro
Downloads
Home   >   mailing lists

Any limitation in size for return result from SELECT? - Mailing list pgsql-sql

From Natasa Bulatovic
Subject Any limitation in size for return result from SELECT?
Date
Msg-id 002e01c2dcd9$b887b2b0$e302b782@ipp.mpg.de
Whole thread Raw
Responses Re: Any limitation in size for return result from SELECT?
Re: Any limitation in size for return result from SELECT?
Re: Any limitation in size for return result from SELECT?
List pgsql-sql
Tree view
Hi,
 
one question
 
Select statement returns as a result concatenated all varchar, text and char columns of a table as one single column ...
 
select col1||col2||col3||.....||col100 from table
 
However, when the number of concatenated columns is bigger than 22 no result is given back (tested in psql, as well as from pgplsql)....
 
Most of these columns for the test data are NULL...Datatypes of columns are mixed text, varchar, char...Select statement does not return any error...Just returns a row with a null result....
Any quick suggestions would be very useful....
 
best regards,
Bulatovic Natasa
 

pgsql-sql by date:

Previous
From: Jack Kiss
Date:
Subject: Inquiry From Form [pgsql]
Next
From: mixo
Date:
Subject: two dates