From: "Nekta Katz" <nekta_k@hotmail.com>
To: pgsql-sql@postgresql.org
Subject: cast lo to oid
Date: Thu, 07 Nov 2002 23:22:26 +1100
Mime-Version: 1.0
Content-Type: text/plain; format=flowed
Message-ID: <F21wAeRaNgEpTX5V3Gy00000652@hotmail.com>

Hi,

I have the following table

create table scan_docs (
    docid   serial,
    shipno numeric(10),
    scan    lo,
    type text
);

when I try to create the following rule

create rule "delete_scan_docs_lo" as
on delete to "scan_docs"
do select lo_unlink (old.scan);

I get the error message

"psql:scan_docs_rule.sql:3: ERROR:  Function 'lo_unlink(lo)' does not exist
Unable to identify a function that satisfies the given argument types
You may need to add explicit typecasts"

So I add a type cast

create rule "delete_scan_docs_lo" as
on delete to "scan_docs"
do select lo_unlink (old.scan::oid);

but I get the following error message

"psql:scan_docs_rule.sql:3: ERROR:  Cannot cast type 'lo' to 'oid' "

Is there away around this?


_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*. 
http://join.msn.com/?page=features/featuredemail