Richard Huxton írta:
On Thursday 08 April 2004 15:21, Sky wrote:
Problem:
pg_loopen() unable to open PostgreSQL large object in...
Solution from another mailing list:
My blob oid was very big.
I had to cast to (float) the oid parameter of pg_loopen.
Sorry, bigger than what? Why float
acter varying, oid)
RETURNS INTEGER
AS
'
BEGIN;
INSERT INTO foto(filename, image) VALUES ( $1, $2 );
COMMIT;
SELECT 1 AS RESULT;
'
LANGUAGE 'sql';
So, What can I do, and how, how can I "CAST" ??
--
Sky
sky AT sylvio .hu
Debian Group - Association of Hungarian Linux Use
ona Crazy ...
I would like to write that function
with plain Sql / LANGUAGE 'sql' /.
CIAO
--
Sky
sky AT sylvio .hu
Debian Group - Association of Hungarian Linux Users
Accessibility Project leader
gpg --keyserver hkp://pgp.mit.edu --recv-keys 314D1B0C
fingerprint = B211 E8C7 C6C2