About OID and the commands/operators STRING( ... )..AS and +

From: "Jarmo Paavilainen" <netletter(at)comder(dot)com>
To: "PostgreSQL lista" <pgsql-general(at)hub(dot)org>
Subject: About OID and the commands/operators STRING( ... )..AS and +
Date: 2000-09-23 17:30:14
Message-ID: 001701c02583$ef1a5e00$1501a8c0@theboss.comder.private
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Louis-David Mitterrand 2000-09-23 17:34:31 Re: running maintenance tasks on DB
Previous Message Stephan Szabo 2000-09-23 17:15:44 Re: About OID and the commands/operators STRING( ... ) ..AS and +