Re: tree structures in sql - my point of view (with request

mallah@trade-india.com wrote:
> 
> Yep! ltree is Faaaast , and i use it at the moment.
> 
> But will it work in INGRES,DB2 or ORACLE  ?
> what if tommorow my boss ask me to use ORACLE?
> 
> I have similar issues in using intarray & arrays in PGSQL
> 
> though reasons of shifting to others dbs are diminishing
> with every major release of PG ;-)

No it will only work on PostgreSQL.  If those other apps had loadable
types, you might be able to do it by rewriting the code to match their
API.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073