Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 194D26328E6 for ; Sun, 30 Aug 2009 16:16:00 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 59194-10 for ; Sun, 30 Aug 2009 19:15:46 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from kuber.nabble.com (kuber.nabble.com [216.139.236.158]) by mail.postgresql.org (Postfix) with ESMTP id 91EB76346C9 for ; Sun, 30 Aug 2009 16:15:49 -0300 (ADT) Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1MhpsS-0003a9-Kt for pgsql-sql@postgresql.org; Sun, 30 Aug 2009 12:15:48 -0700 Message-ID: <25214694.post@talk.nabble.com> Date: Sun, 30 Aug 2009 12:15:48 -0700 (PDT) From: db1981 To: pgsql-sql@postgresql.org Subject: Searching for byte values within a bytea field MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: damiano.bolzoni@securitymatters.eu X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 200908/154 X-Sequence-Number: 33063 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.