Jeremy Taylor

Results 242 comments of Jeremy Taylor

[Jeremy Taylor](https://www.linkedin.com/in/jdtaylor/) - [JUXT](https://www.juxt.pro/)

Possibly related to https://github.com/xtdb/xtdb/issues/2373 (IIOBE is similarly showing `length: 1 (expected: range(0, 0))`)

Hey @jr200 - thanks for opening the issue! > I [...] wondered if the long term intention is to achieve some kind of full-feature compatibility with postgresql? The short answer...

Noting that Psycopg3 will use this query that relies on `::regtype` and `to_regtype()` (neither of which we support currently) ``` SELECT typname AS name, oid, typarray AS array_oid, oid::regtype::text AS...

That `TO` is shown in the railroad grammar, and is explicitly described as optional: ![Image](https://github.com/user-attachments/assets/221442af-ed21-414a-a0c0-7f9737021c18) ...so not a bug, strictly speaking, but I agree it seems superfluous (and confusing) in...

Yes the TOC still contains clickable links that scroll the page, but they _both_ scroll to the same `db` heading because GitHub ignores the case-sensitivity of the two otherwise distinct...

I reckon always adding a positional index as a suffix to the tag names regardless (`-1`, `-2`, `-3`, etc.) would never fail to disambiguate all the generated/interpreted links. It would...

I think this is because the inner SELECT can't "see" the scope from the outer query (unlike the non-pipeline SELECT), it only has access to the columns that are passed...