X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id C982E9DC857 for ; Tue, 21 Feb 2006 19:43:11 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 72919-02 for ; Tue, 21 Feb 2006 19:43:14 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from chrobd01.vailsys.com (chrobd01.vailsys.com [63.210.102.138]) by postgresql.org (Postfix) with ESMTP id DDC859DC847 for ; Tue, 21 Feb 2006 19:43:09 -0400 (AST) Received: from dfsfbd06.vail (dfsfbd06.vail [192.168.129.190]) by chrobd01.vailsys.com (Postfix) with ESMTP id 713484976; Tue, 21 Feb 2006 17:43:12 -0600 (CST) Received: from [192.168.129.15] (ltwddurham.vail [192.168.129.15]) by dfsfbd06.vail (Postfix) with ESMTP id 59CFF323FC5; Tue, 21 Feb 2006 17:43:12 -0600 (CST) Message-ID: <43FBA58F.5020706@vailsys.com> Date: Tue, 21 Feb 2006 17:43:11 -0600 From: David Durham User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Peter Eisentraut Cc: pgsql-admin@postgresql.org Subject: Re: binary data types and streaming References: <43FB7EA2.8080003@vailsys.com> <200602212231.16715.peter_e@gmx.net> In-Reply-To: <200602212231.16715.peter_e@gmx.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200602/247 X-Sequence-Number: 20668 Peter Eisentraut wrote: >> Is there any type of streaming support built into postgres' >>binary datatype handling? For instance, can I specify a beginning >>offset for the binary data that I want > > substring and other such functions are available. Thanks. I didn't realize that string functions could be used on bytea columns. -Dave