X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 8832C4758BD for ; Tue, 25 Feb 2003 09:20:47 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 18808-09 for ; Tue, 25 Feb 2003 09:20:36 -0500 (EST) Received: from post.rzg.mpg.de (post.rzg.mpg.de [130.183.9.21]) by postgresql.org (Postfix) with ESMTP id 51B76474E42 for ; Tue, 25 Feb 2003 09:20:25 -0500 (EST) Received: from zim03vm (zim03vm.ipp.mpg.de [130.183.2.227]) by post.rzg.mpg.de (8.9.2/8.9.2) with SMTP id PAA93574 for ; Tue, 25 Feb 2003 15:20:26 +0100 X-Envelope-To: Message-ID: <002e01c2dcd9$b887b2b0$e302b782@ipp.mpg.de> From: "Natasa Bulatovic" To: Subject: Any limitation in size for return result from SELECT? Date: Tue, 25 Feb 2003 15:25:17 +0100 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_002B_01C2DCE2.1A12E240" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Virus-Scanned: by amavisd-new X-Archive-Number: 200303/26 X-Sequence-Number: 12066 This is a multi-part message in MIME format. ------=_NextPart_000_002B_01C2DCE2.1A12E240 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, one question Select statement returns as a result concatenated all varchar, text and cha= r 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 resul= t 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...J= ust returns a row with a null result.... Any quick suggestions would be very useful.... best regards, Bulatovic Natasa ------=_NextPart_000_002B_01C2DCE2.1A12E240 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi,

one question

Select statement returns as a result conca= tenated=20 all varchar, text and char columns of a table as one single column=20 ...

select col1||col2||col3||.....||col100 fro= m=20 table

However, when the number of concatenated c= olumns is=20 bigger than 22 no result is given back (tested in psql, as well as from=20 pgplsql)....

Most of these columns for the test data ar= e=20 NULL...Datatypes of columns are mixed text, varchar, char...Select statemen= t=20 does not return any error...Just returns a row with a null=20 result....

Any quick suggestions would be very=20 useful....

best regards,

Bulatovic Natasa

------=_NextPart_000_002B_01C2DCE2.1A12E240--