Hello
I'm aware of the automatic transaction abort that occurs in PostgreSQL if
you have DML throw an error during a transaction, this prevents future
selects within transaction, until rollback or commit (and hence, new
transaction). I'm okay with this.
Doing all this on Red Hat 6.5 with
Hello
I have a table, and I want to always supply predicates in a BETWEEN format.
If all data is to be returned, then the FROM and TO values of the
BETWEEN are set to low hex value, and high hex value.
Sometimes this is not returning rows, here's an example:
e5iso=# create table t1 (col1
Actually I find this returns my row:
select col1 from t1 where col1 BETWEEN E'\x01\x01\x01' AND
E'\xFF\xFF\xFF' or col1=E'\x20';
Why does x'202020' match an equality condition on E'\x20' ?
Is there some auto trimming going on?
This is PostgreSQL 9.3.5 on Linux
On 14 November 2014 11:41, Gary
