About OID and the commands/operators STRING( ... )..AS and + - Mailing list pgsql-general

From Jarmo Paavilainen
Subject About OID and the commands/operators STRING( ... )..AS and +
Date
Msg-id 001701c02583$ef1a5e00$1501a8c0@theboss.comder.private
Whole thread Raw
In response to Re: About OID and the commands/operators STRING( ... ) ..AS and +  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Responses Re: About OID and the commands/operators STRING( ... )..AS and +
List pgsql-general
...
> > I suspect that OID are reused, but how fast are they reused?
>
> IIRC, they are not reused at all.

Not even if a row is deleted?
Wont PostgreSQL run out of OID after a while (maybe long time, but anyway).

...
> > And does PostgreSQL support the STRING and AS command?
...
> What does STRING do?  I don't see a function with that name, but
> it's possible we have it with a different name.
> If it's just cast value to a string, then use text(field) or

Cast to string... Exactly what I was looking for, thanx. (Maybe STRING(...)
is Sybase stuff).

// Jarmo


pgsql-general by date:

Previous
From: Alexander Steinert
Date:
Subject: union on views
Next
From: Stephan Szabo
Date:
Subject: Re: About OID and the commands/operators STRING( ... )..AS and +