X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 0430E56666 for ; Mon, 21 Mar 2005 16:13:02 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 41691-10 for ; Mon, 21 Mar 2005 16:12:56 +0000 (GMT) Received: from resmta04.ono.com (smtp.ono.com [62.42.230.12]) by svr1.postgresql.org (Postfix) with ESMTP id E9CE7565E0 for ; Mon, 21 Mar 2005 16:12:54 +0000 (GMT) Received: from [80.58.11.235] by resmta04.ono.com with HTTP; Mon, 21 Mar 2005 17:12:52 +0100 Date: Mon, 21 Mar 2005 17:12:52 +0100 Message-ID: <422CFD5E0000A55E@resmta04.ono.com> From: juanmime@ono.com Subject: Resizing images contained in oid fields To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-15" Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.49 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, NO_REAL_NAME X-Spam-Level: * X-Archive-Number: 200503/325 X-Sequence-Number: 16823 Hello, I have a table where an oid field is used for saving images. I'm thinking= about getting a little snapshot of all images without downloading the ful= l images. I only want to download some entire images. I'm thinking in somet= hing like this: create table images ( id serial primary key, title varchar not null, photo_id oid ); select title, snapshot(photo_oid, 120, 120) as snap from images In this case, the snapshot function returns the resized snapshot of the o= riginal image. I think that the core of function could be similar to this: 1) Obtain the image 2) Resize the Image to new size 3) Return the Resized Image Do you know if there exists a function like this ("snapshot")? Otherwise, What is the type returned by the function ? What suitable proc= edure language should I use ? What image library for the redimension ? Thanks you very much.