Re: Records, Types, and Arrays - Mailing list pgsql-general

From David G. Johnston
Subject Re: Records, Types, and Arrays
Date
Msg-id CAKFQuwYA-Q0rOS5d8RWM0t-kpTiE4Ka7KmF0OUBfWxeGD=N81g@mail.gmail.com
Whole thread Raw
In response to Re: Records, Types, and Arrays  (Raymond Brinzer <ray.brinzer@gmail.com>)
List pgsql-general
The convention here is to inline or, at worse, bottom post, trimming irrelevant context.

On Friday, May 19, 2023, Raymond Brinzer <ray.brinzer@gmail.com> wrote:

I'm guessing that row() isn't really a function, then?  And even so, assuming this is the important difference, how is the ability to change row structure on the fly making the cast possible?  In what way would the query calling get_row() be critical?

Row() is pure syntax. It distinguishes (col) vs. row(col) where the first is just a column in parentheses and the second is a composite with one column member.

 David J.

pgsql-general by date:

Previous
From: sujay kadam
Date:
Subject: How to connect with PostgreSQL Database with SSL using Certificates and Key from client Eclipse in Java
Next
From: Martin Mueller
Date:
Subject: Re: a simple-minded question about updating