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

Поиск
Список
Период
Сортировка
От Jarmo Paavilainen
Тема About OID and the commands/operators STRING( ... )..AS and +
Дата
Msg-id 001701c02583$ef1a5e00$1501a8c0@theboss.comder.private
обсуждение исходный текст
Ответ на Re: About OID and the commands/operators STRING( ... ) ..AS and +  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Ответы Re: About OID and the commands/operators STRING( ... )..AS and +  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список 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 по дате отправления:

Предыдущее
От: Alexander Steinert
Дата:
Сообщение: union on views
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: About OID and the commands/operators STRING( ... )..AS and +