Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Sync list_slice documentation with changes introduced after 0.8.0 #2655

Closed
taniabogatsch opened this issue Apr 3, 2024 · 1 comment · Fixed by #2656
Closed

Sync list_slice documentation with changes introduced after 0.8.0 #2655

taniabogatsch opened this issue Apr 3, 2024 · 1 comment · Fixed by #2656

Comments

@taniabogatsch
Copy link
Contributor

Changes introduces by duckdb/duckdb#8087.

As per issue duckdb/duckdb#3176, slicing in DuckDB used NULL as the unbounded marker, which was not compatible with Postgres, which returns NULL if the lower or upper bound is NULL.

Related issue: duckdb/duckdb#11431
Related link to the documentation: https://duckdb.org/docs/sql/functions/char.html#array_slicelist-begin-end
@taniabogatsch taniabogatsch mentioned this issue Apr 3, 2024
Closed
1 task
@szarnyasg
Copy link
Collaborator

@taniabogatsch thanks, I'll change the example.

szarnyasg added a commit to szarnyasg/duckdb-web that referenced this issue Apr 3, 2024
@szarnyasg
Add and fix examples for array_slice function
5cf7a83 
Fixes duckdb#2655
@szarnyasg szarnyasg mentioned this issue Apr 3, 2024
Merged
szarnyasg added a commit to szarnyasg/duckdb-web that referenced this issue Apr 3, 2024
@szarnyasg
Add and fix examples for array_slice function
c857d9d 
Fixes duckdb#2655
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Add and fix examples for array_slice function szarnyasg/duckdb-web
2 participants
@szarnyasg @taniabogatsch