generating non-unicode 8-bit text data in SQL_ASCII encoding

Started by Bruce Momjianabout 18 years ago1 messageshackers
Jump to latest
#1Bruce Momjian
bruce@momjian.us

In trying to generate random incompressible data I ran into this. I thought we
said char()/ascii() would be allowed to generate either unicode code points if
your encoding was unicode or 8-bit ascii if it's SQL_ASCII.

Is there any way to generate random 8-bit characters in SQL_ASCII encoding
now?

postgres=# \l
List of databases
Name | Owner | Encoding
-----------+-------+-----------
postgres | stark | SQL_ASCII
template0 | stark | SQL_ASCII
template1 | stark | SQL_ASCII
(3 rows)

postgres=# select "char"((random()*255)::integer+1);
char
------
'
(1 row)

postgres=# select "char"((random()*255)::integer+1);
ERROR: "char" out of range
postgres=# select "char"((random()*255)::integer+1);
ERROR: "char" out of range

--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's Slony Replication support!