Tutorial 26 - Searching Arrays(3/3) Video Lecture | Postgresql: A Complete Tutorial - Database Management

hello guys welcome to our tutorial of
PostgreSQL in this tutorial I'm going to
tell you how to do searching in your
heiress
so searching is basically done to drive
some data that you want to access in
your errors or if you want to put some
conditions to sort or filter your errors
you could just do so icing in areas so
I'll tell you how to do so icing so you
could just do select star from silent
disco EMP where they'd be the first
equal to 10,000 pay or second equal to
10,000 third equal to 10,000 fourth
equal to 10,000 so this would give me
details of those employees whose either
first index pay is 10,000 second is
10,000 or third is 10,000 of 14,000 so
you would see only reishi that is he has
only 10,000 salary of the first one so
it gives me this otherwise you could
just do it again that is select strong
underscore EMP and you would see that
will has 25,000 unicorn so that is why
it's not getting to it so this method
that we used the last time that is this
one so this is very complex in case we
do in case for large areas and if we
don't know the size of Aries so what you
could do is a very small step instead of
this you could just use the any operator
that is where thousand ten thousand
equals to any pay
now what this means is that any of the
index can be equal to 10,000 so when you
run this query you would see that
oops note this you just Baker's yeah so
you could see that it gives me the same
result as any of the payment can be
equal to 10,000 now similar to this is
another operator that is all so that
means the all on all the indexes in an
error should equal to a particular field
so for example we have Rahul whose each
and every index equal to 25,000 so if I
do all I will just get this you would
say I get traveled because all of his
indexes are equal to 25,000 so this
motherf use its few ways in which you
could do searching in your Aires so
thank you boys tutorial subscribe for
more and stay tuned