| From: | PG Doc comments form <noreply(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-docs(at)lists(dot)postgresql(dot)org |
| Cc: | rsindlin(at)gmail(dot)com |
| Subject: | bytea documentation error |
| Date: | 2023-03-17 16:56:52 |
| Message-ID: | 167907221210.1803488.5939223864945604536@wrigleys.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/15/datatype-binary.html
Description:
I believe there is a documentation error in the example for "8.4.1 bytea Hex
Format"
(https://www.postgresql.org/docs/current/datatype-binary.html#id-1.5.7.12.9)
The example is
`SELECT '\xDEADBEEF';`
However, when I try that on my system [psql (13.9 (Ubuntu
13.9-1.pgdg20.04+1), server 13.10 (Ubuntu 13.10-1.pgdg20.04+1))], it works
*but* the result is type `text` per `pg_typeof()`. I believe the example
needs to be corrected with an explicit cast to `bytea`.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2023-03-18 20:05:01 | Re: bytea documentation error |
| Previous Message | Laurenz Albe | 2023-03-16 19:48:58 | Re: Nulls Not Distinct in Unique Indexes secton |