Re: Overloaded && operator from intarray module prevents index usage. - Mailing list pgsql-general

From Andrew Gierth
Subject Re: Overloaded && operator from intarray module prevents index usage.
Date
Msg-id 877edjdjqx.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to Re: Overloaded && operator from intarray module prevents index usage.  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-general
>>>>> "Ron" == Ron  <ronljohnsonjr@gmail.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)


pgsql-general by date:

Previous
From: David Steele
Date:
Subject: Re: Pgbackrest Comparability issue
Next
From: David Steele
Date:
Subject: Re: Barman disaster recovery solution