Thread: BUG #16494: cant use row['field name']

BUG #16494: cant use row['field name']

From
PG Bug reporting form
Date:
The following bug has been logged on the website:

Bug reference:      16494
Logged by:          Preeth TYK
Email address:      preetha@tyk.jp
PostgreSQL version: 12.3
Operating system:   Windows
Description:

I am using pgsql with php. When trying to echo data in tables using
row['field name'] , it is returning error. I am currently using
row['row_number'] which is really inconvenient.


Re: BUG #16494: cant use row['field name']

From
Pavel Stehule
Date:
Hi

po 15. 6. 2020 v 8:52 odesílatel PG Bug reporting form <noreply@postgresql.org> napsal:
The following bug has been logged on the website:

Bug reference:      16494
Logged by:          Preeth TYK
Email address:      preetha@tyk.jp
PostgreSQL version: 12.3
Operating system:   Windows
Description:       

I am using pgsql with php. When trying to echo data in tables using
row['field name'] , it is returning error. I am currently using
row['row_number'] which is really inconvenient.

If it is an issue, then it is a PHP API issue. This is a PostgreSQL bug list.

You wrote nothing about the API that you use. Probably it is an older PG driver. a PDO driver works differently.

But I don't think so this is a bug. Building an int indexed array is faster than building a string indexed array. This API is pretty old, and had strong benefits on slower computers.

If you want different access, then you can you different API


Regards

Pavel Stehule