On 11.09.24 13:35, Hunaid Sohail wrote:
> Hi Jim,
>
> On Wed, Sep 11, 2024 at 3:03 PM Jim Jones <jim.jones@uni-muenster.de>
> wrote:
>
> Thanks for working on this.
>
> Any particular reason for the design change? In v28 it returned a
> table
> with a single row and multiple columns --- one column per
> attribute. But
> now it returns multiple rows. In this case, I was expecting 1 row
> with 7
> columns instead of 7 rows with 2 columns.
>
>
> I am not sure which design you are referring to.
> I haven't applied the v28 patch but the original author in thread [1]
> provided sample output. The output is in tabular form with 2 columns
> and multiple rows.
>
>
[1] https://www.postgresql.org/message-id/CP8P284MB249615AED23882E1E185C8ABEC3C2%40CP8P284MB2496.BRAP284.PROD.OUTLOOK.COM
>
It may look like this, but it is a single record --- mind the header "-[
RECORD 1 ]----------------+---------".
psql was called in expanded mode:
> $ /home/pgsql-17devel/bin/psql -x -p 5432
"-x" or "--expanded"
Example:
$ psql postgres -xc "SELECT 'foo' col1, 'bar' col2"
-[ RECORD 1 ]
col1 | foo
col2 | bar
--
Jim
