Re: [GENERAL] Oid problem

2004-04-08 Thread Sky
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

[GENERAL] Oid problem

2004-04-08 Thread Sky
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

[GENERAL] FUNCTION problem

2004-04-01 Thread Sky
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