Re: Yet another binary vs. text question (with a twist?)

From: David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Yet another binary vs. text question (with a twist?)
Date: 2014-12-17 03:35:24
Message-ID: 1418787324458-5831033.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Scott Robertson 2014-12-17 04:10:42 warning about console code page on starting psql
Previous Message Jan Danielsson 2014-12-17 03:12:50 Yet another binary vs. text question (with a twist?)