lidavidm commented on issue #538:
URL: https://github.com/apache/arrow-adbc/issues/538#issuecomment-1609936389
Hmm, I'm not able to replicate this.
I created a table:
```sql
postgres=# CREATE TABLE my_table (string_field TEXT, date_field DATE);
CREATE TABLE
postgres=# INSERT INTO my_table VALUES ('a', '2023-05-10'), ('b',
'2023-05-11'), ('c', '2023-05-12');
INSERT 0 3
postgres=# SELECT * FROM my_table;
string_field | date_field
--------------+------------
a | 2023-05-10
b | 2023-05-11
c | 2023-05-12
(3 rows)
```
Then I ran your query with polars:
```python
>>> import polars
>>> import polars as pl
>>> uri =
'postgres://localhost:5432/postgres?user=postgres&password=password'
>>> query = '''SELECT string_field
... FROM my_table
... WHERE date_field = '2023-05-10'
... ORDER BY string_field'''
>>> pl.read_database(query, connection_uri=uri, engine='adbc')
shape: (1, 1)
┌──────────────┐
│ string_field │
│ --- │
│ str │
╞══════════════╡
│ a │
└──────────────┘
>>> pl.__version__
'0.18.4'
```
--
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]
