Re: [QUESTIONS] Arrays (inserting and removing)

Marc G. Fournier <scrappy@hub.org>

From: The Hermit Hacker <scrappy@hub.org>
To: Karl Denninger <karl@mcs.net>
Cc: "Vadim B. Mikheev" <vadim@sable.krasnoyarsk.su>, Ralf Mattes <mattes@mhs.uni-freiburg.de>, Gyepi Sam <gsam@praxis-sw.com>, Michael J Schout <mschout@mail.gkg-com.com>, pgsql-hackers@postgreSQL.org, pgsql-questions@postgreSQL.org
Date: 1998-01-15T15:40:43Z
Lists: pgsql-hackers
 
> OIDs are a bastardization of the relational model.  If you have to keep
> them, then do so, but their use should be SEVERELY discouraged.

	Actually, I use them quite extensively...I have several WWW-based
search directories that are searched with:

select oid,<fields> from <table> where <search conditions>;

	That display minimal data to the browser, and then if someone
wants more detailed information, I just do:

select * from <table> where oid = '';

	Its also great if you mess up the original coding for a table and
want to remove 1 of many duplicates that you've accidently let pass
through :(