From: | "Premsun Choltanwanich" <Premsun(at)nsasia(dot)co(dot)th> |
---|---|
To: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | lo function changed in PostgreSQL 8.1.1 (ask again) |
Date: | 2005-12-22 02:44:35 |
Message-ID: | 43AA7581.C5F7.004C.0@nsasia.co.th |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
From contrib/lo I found that it has something difference between old and new version of PostgreSQL. And I'm sure that I already tick on Large Object (lo) option when I install.
How can I manage on difference function?
:::New Version:::
DOMAIN lo AS pg_catalog.oid;
FUNCTION lo_oid(lo) RETURNS pg_catalog.oid AS 'SELECT $1::pg_catalog.oid' LANGUAGE SQL STRICT IMMUTABLE;
FUNCTION lo_manage() RETURNS pg_catalog.trigger AS '$libdir/lo' LANGUAGE C;
:::Old Version:::
FUNCTION lo_in(cstring) RETURNS lo AS '$libdir/lo' LANGUAGE C IMMUTABLE STRICT;
FUNCTION lo_out(lo) RETURNS cstring AS '$libdir/lo' LANGUAGE C IMMUTABLE STRICT;
TYPE lo ( INTERNALLENGTH = 4, EXTERNALLENGTH = variable, INPUT = lo_in, OUTPUT = lo_out);
FUNCTION lo_oid(lo) RETURNS oid AS '$libdir/lo' LANGUAGE C IMMUTABLE STRICT;
FUNCTION oid(lo) RETURNS oid AS '$libdir/lo', 'lo_oid' LANGUAGE C IMMUTABLE STRICT;
CAST (lo as oid) WITH FUNCTION oid(lo) AS IMPLICIT;
FUNCTION lo(oid) RETURNS lo AS '$libdir/lo' LANGUAGE C IMMUTABLE STRICT;
CAST (oid as lo) WITH FUNCTION lo(oid) AS IMPLICIT;
FUNCTION lo_manage() RETURNS trigger AS '$libdir/lo' LANGUAGE C;
From | Date | Subject | |
---|---|---|---|
Next Message | Matthew Smith | 2005-12-22 02:59:01 | Re: Help on a complex query (avg data for day of the week) |
Previous Message | Michael Fuhr | 2005-12-22 02:37:55 | Re: Help on a complex query (avg data for day of the week) |