Searching for byte values within a bytea field - Mailing list pgsql-sql

From db1981
Subject Searching for byte values within a bytea field
Date
Msg-id 25214694.post@talk.nabble.com
Whole thread Raw
List pgsql-sql
Hi all,
I got stuck with a problem. I have a table that stores binary content into a
bytea field. Now, I would like to be able to search for specific byte
sequences, such as '48545450' ('HTTP'). I can execute a "SELECT myfield FROM
mytable WHERE myfield LIKE '%HTTP%' ", but I cannot do the same when looking
for byte values...

Thanks for helping! 
-- 
View this message in context:
http://www.nabble.com/Searching-for-byte-values-within-a-bytea-field-tp25214694p25214694.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.



pgsql-sql by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: NEED HELP COPY TO DYNAMIC OUTPUT FILE
Next
From: "Yogi Dwianandono Rizkiadi"
Date:
Subject: Re: NEED HELP COPY TO DYNAMIC OUTPUT FILE