Closed johnsmyth closed 3 years ago
These work individually, but not both via where ... in
where ... in
> select * from rss_item where feed_link in ('https://steampipe.io/blog/feed.xml', 'http://feeds.feedburner.com/AmazonWebServicesBlog') +-------+------+--------------+-------------+------------+---------+-------------+------------+------------+-----------+------+-------------+-----------+-----------+---------+ | title | link | author_email | author_name | categories | content | description | enclosures | extensions | feed_link | guid | image_title | image_url | published | updated | +-------+------+--------------+-------------+------------+---------+-------------+------------+------------+-----------+------+-------------+-----------+-----------+---------+ +-------+------+--------------+-------------+------------+---------+-------------+------------+------------+-----------+------+-------------+-----------+-----------+---------+ > > select * from rss_item where feed_link in ('https://steampipe.io/blog/feed.xml') +---------------------------------------------------+--------------------------------------------------------------------------------+--------------+-------------+------------+---------+------ | title | link | author_email | author_name | categories | content | descr +---------------------------------------------------+--------------------------------------------------------------------------------+--------------+-------------+------------+---------+------ | Top 10 Checks: IAM Credential Report | https://steampipe.io/blog/aws-iam-credential-report-top-10-checks | <null> | <null> | <null> | <null> | Learn | Analysis of Cloud Provider Market Share – 2021 | https://steampipe.io/blog/aws-azure-gcp-where-to-build | <null> | <null> | <null> | <null> | Using | Corral your untagged cloud cattle | https://steampipe.io/blog/finding-untagged-resources | <null> | <null> | <null> | <null> | How t | The Hitchhiker's Guide to IAM Policy Wildcards | https://steampipe.io/blog/aws-iam-policy-wildcards-reference | <null> | <null> | <null> | <null> | A qui | New: AWS Multi-Region Queries and Query Caching | https://steampipe.io/blog/release-0-2-0 | <null> | <null> | <null> | <null> | Learn | Monitor compliance of the AWS CIS 1.15 benchmark. | https://steampipe.io/blog/aws-cis-1-15-ensure-iam-users-have-group-permissions | <null> | <null> | <null> | <null> | Ensur | Normalizing AWS IAM Policies for Automation | https://steampipe.io/blog/normalizing-aws-iam-policies-for-automated-analysis | <null> | <null> | <null> | <null> | Uncov | Steampipe ❤ Parliament | https://steampipe.io/blog/steampipe-builds-on-parliament-aws-iam | <null> | <null> | <null> | <null> | How S | Steampipe: select * from cloud; | https://steampipe.io/blog/introducing-steampipe | <null> | <null> | <null> | <null> | The e +---------------------------------------------------+--------------------------------------------------------------------------------+--------------+-------------+------------+---------+------ > select * from rss_item where feed_link in ('http://feeds.feedburner.com/AmazonWebServicesBlog' ) +-------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------+---------- | title | link | author_em +-------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------+---------- | AWS Fault Injection Simulator – Use Controlled Experiments to Boost Resilience | http://feedproxy.google.com/~r/AmazonWebServicesBlog/~3/5dAf2jYNI4o/ | | | | ...
These work individually, but not both via
where ... in