Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
array comparison
--PostgreSQL 9.6 --'\\' is a delimiter select '{1,2,3}'::int[] = '{3,2,1}'::int[], --false '{1,2,3}'::int[] && '{3,2,1}'::int[], --true, but see next example '{1,2,3}'::int[] && '{3,2,1, 4}'::int[], -- as you see that additional element did not make the result false, '{1,2,3}'::int[] && '{3,2,1, 4}'::int[] and array_length('{1,2,3}'::int[], 1) = array_length('{3,2,1, 4}'::int[], 1), -- as you see that additional element did not make the result false, '{1,2,3}'::int[] && '{3,2,1, 4}'::int[] and array_length('{1,2,3}'::int[], 1) = array_length('{3,2,1}'::int[], 1) -- valid comparison
run
|
edit
|
history
|
help
0
PostgreSQL Sandbox: Legitimate Resale
2
How i can get the difference of closest two date in two table join in postgresql
loggin_trigger-audit
book suggestion
hell
FinaleNFJNDFJKSN
Atuação
Select rows with no intersection on join table and check by date
Movie Rating SQL Analysis Project