The Artima Developer Community
Sponsored Link

Java Buzz Forum
Does PostgreSQL Have an ORA-01795-like Limit?

0 replies on 1 page.

Welcome Guest
  Sign In

Go back to the topic listing  Back to Topic List Click to reply to this topic  Reply to this Topic Click to search messages in this forum  Search Forum Click for a threaded view of the topic  Threaded View   
Previous Topic   Next Topic
Flat View: This topic has 0 replies on 1 page
justin cater

Posts: 19616
Nickname: justin78
Registered: Mar, 2011

Justin Cater is executive editor at Java Code Geeks
Does PostgreSQL Have an ORA-01795-like Limit? Posted: Nov 12, 2015 10:10 AM
Reply to this message Reply

This post originated from an RSS feed registered with Java Buzz by justin cater.
Original Post: Does PostgreSQL Have an ORA-01795-like Limit?
Feed Title: Java Code Geeks
Feed URL: http://feeds.feedburner.com/JavaCodeGeeks
Feed Description: Java 2 Java Developers Resource Center
Latest Java Buzz Posts
Latest Java Buzz Posts by justin cater
Latest Posts From Java Code Geeks

Advertisement
The Oracle database requires that no more than 1000 entries be used in a SQL IN portion of a WHERE clause and will throw an ORA-01795 error if that number is exceeded. If a value needs to be compared to more than 1000 values, approaches other than use of IN must be applied. I wondered ...

Read: Does PostgreSQL Have an ORA-01795-like Limit?

Topic: Getting Started with the MapR Command Line (Part I) Previous Topic   Next Topic Topic: Beware of Functional Programming in Java!

Sponsored Links



Google
  Web Artima.com   

Copyright © 1996-2019 Artima, Inc. All Rights Reserved. - Privacy Policy - Terms of Use