Re: Overloaded && operator from intarray module prevents index usage.

From: Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
To: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Overloaded && operator from intarray module prevents index usage.
Date: 2019-03-01 09:32:37
Message-ID: 877edjdjqx.fsf@news-spur.riddles.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>>>>> "Ron" == Ron <ronljohnsonjr(at)gmail(dot)com> writes:

Ron> Arrays are -- by definition -- not atomic, and so they
Ron> fundamentally break the model that relational databases are
Ron> founded upon.  If you want to be a good database designer, don't
Ron> use arrays.

"In theory there is no difference between theory and practice, but in
practice there is."

Sometimes a good database designer has to tell the theoreticians where
to get off, and do something more pragmatic.

--
Andrew (irc:RhodiumToad)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Steele 2019-03-01 09:40:01 Re: Barman disaster recovery solution
Previous Message David Steele 2019-03-01 09:31:33 Re: Pgbackrest Comparability issue