Dump (was: Intervals and ISO 8601 duration)

From: "Peter J(dot) Holzer" <hjp-pgsql(at)hjp(dot)at>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Dump (was: Intervals and ISO 8601 duration)
Date: 2023-01-14 05:50:33
Message-ID: 20230114055033.zomqvfbdh7pxgn4z@hjp.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2023-01-14 06:32:03 +0100, Peter J. Holzer wrote:
> Oracle has a function which returns the internal representation of a
> value as a series of (decimal) byte values. Back in the days when I was
> new to Oracle I used this to figure out how Oracle stores NUMBER, but
> now I've forgotten the name of the function. Maybe adding something like
> this to PostgreSQL would be worthwhile?

Found it:

| DUMP
|
| Syntax
|
| DUMP(expr[, return_fmt [, start_position [, length ] ] ])
|
| Purpose
|
| DUMP returns a VARCHAR2 value containing the data type code, length in
| bytes, and internal representation of expr. The returned result is
| always in the database character set. For the data type corresponding to
| each code, see Table 2-1, "Built-in Data Type Summary".
|
| The argument return_fmt specifies the format of the return value and can
| have any of the following values:
|
| * 8 returns result in octal notation.
|
| * 10 returns result in decimal notation.
|
| * 16 returns result in hexadecimal notation.
|
| * 17 returns each byte printed as a character if and only if it can be
| interpreted as a printable character in the character set of the
| compiler—typically ASCII or EBCDIC. Some ASCII control characters
| may be printed in the form ^X as well. Otherwise the character is
| printed in hexadecimal notation. All NLS parameters are ignored. Do
| not depend on any particular output format for DUMP with return_fmt
| 17.
|
| By default, the return value contains no character set information. To
| retrieve the character set name of expr, add 1000 to any of the
| preceding format values. For example, a return_fmt of 1008 returns the
| result in octal and provides the character set name of expr.
|
| The arguments start_position and length combine to determine which
| portion of the internal representation to return. The default is to
| return the entire internal representation in decimal notation.
|
| If expr is null, then this function returns NULL.
|
| This function does not support CLOB data directly. However, CLOBs can be
| passed in as arguments through implicit data conversion.

hp

--
_ | Peter J. Holzer | Story must make more sense than reality.
|_|_) | |
| | | hjp(at)hjp(dot)at | -- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challenge!"

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2023-01-14 06:01:00 Re: Intervals and ISO 8601 duration
Previous Message Peter J. Holzer 2023-01-14 05:32:03 Re: Intervals and ISO 8601 duration