Postgres Pro
Downloads
Home   >   mailing lists

Re: Yet another binary vs. text question (with a twist?) - Mailing list pgsql-novice

From David G Johnston
Subject Re: Yet another binary vs. text question (with a twist?)
Date
Msg-id 1418787324458-5831033.post@n5.nabble.com
Whole thread Raw
In response to Yet another binary vs. text question (with a twist?)  (Jan Danielsson <jan.m.danielsson@gmail.com>)
List pgsql-novice
Tree view 
Jan Danielsson-3 wrote
>    The hashes really have no reason to be stored in any other format
> than their raw binary format, except I've read that SQL99 doesn't allow
> binary columns to be indexed -- which would be a problem because the
> hashes most definitely will need to be indexed.  Is it correct that
> blob's can't be indexed?

FWICS you can index columns defined as "bytea" in PostgreSQL

David J.






--
View this message in context:
http://postgresql.nabble.com/Yet-another-binary-vs-text-question-with-a-twist-tp5831031p5831033.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.

pgsql-novice by date:

Previous
From: Jan Danielsson
Date:
Subject: Yet another binary vs. text question (with a twist?)
Next
From: Scott Robertson
Date:
Subject: warning about console code page on starting psql