[QUESTIONS] builtin lo_unlink(int4)? why int4 not oid?

From: "Park, Chul-Su" <pcs(at)mhlx01(dot)kek(dot)jp>
To: pgsql-hackers(at)postgresql(dot)org
Subject: [QUESTIONS] builtin lo_unlink(int4)? why int4 not oid?
Date: 1998-06-13 02:18:30
Message-ID: 3581E176.2885E0FF@mhlx01.kek.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello all,

e.g.

I want to delete a large object with this table

CREATE TABLE image (
name text,
raster oid
);

-- from programmer's guide

in the psql

foo=> select lo_unlink(raster) from image;
ERROR: function int4(oid) does not exist

Why builtin "lo_unlink" is defined as accepting int4 not oid? Then do I
have to do
foo=> select lo_unlink(int4(oid_text(raster))) from image;
OR
define "raster" as int4? I don't think all these are good idea... Then
how to delete "lo" in the "psql"?

Best Regards,
C.S.Park

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message rmcm 1998-06-13 03:37:03 Re: [GENERAL] COALESCE() or NVL()
Previous Message Bruce Momjian 1998-06-12 23:17:27 template names