WillAyd commented on PR #1502:
URL: https://github.com/apache/arrow-adbc/pull/1502#issuecomment-1919953341
> Though, I'm not sure how the reference data was generated; it looks to be
by running a query and saving the output/translating it to a byte array:
What I typically do is COPY out to a file then check the file in a hex
editor. That way nothing with the terminal or keyring ends mixing up the bytes
e.g.
```
postgres=# COPY (SELECT CAST(col AS NUMERIC) AS col FROM ( VALUES
(1000000), ('0.00001234'), ('1.0000'), (-123.456), (123.456), ('nan'),
('-inf'), ('inf'), (NULL)) AS drvd(col)) TO '/tmp/pgdata.out' WITH (FORMAT
binary);
```
Will write the bytes out to /tmp/pgdata.out
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
