Is it possible to "truncate" a LOB?

Поиск
Список
Период
Сортировка
От Stephen Crawley
Тема Is it possible to "truncate" a LOB?
Дата
Msg-id 200006082329.e58NTUb02892@piglet.dstc.edu.au
обсуждение исходный текст
Список pgsql-sql
[I asked this question on the "interfaces" list, but nobody answered ...]

Suppose that I have created a LOB, written a bunch of data to it, and 
committed.

Is it now possible to rewrite the LOB to contain a lesser amount of data?
In other words can I do the equivalent of UNIX open(..., O_WRONLY | O_TRUNC) 
or ftruncate(...) on a LOB?

Or am I forced to delete the existing LOB and create a new one if I want
to shrink the size of the stored data?

-- Steve










В списке pgsql-sql по дате отправления:

Предыдущее
От: Brian Powell
Дата:
Сообщение: Help with inserts into Views
Следующее
От: Oliver Graf
Дата:
Сообщение: RE: SQL 'Case When...'