[SQL] demo of using large objects interface in php

FUNCTION lo_test_del () RETURNS OPAQUE AS ' BEGIN perform lo_unlink(OLD.raster); RETURN OLD; END; ' LANGUAGE 'plpgsql'; CREATE TRIGGER "tg_lo_test_del" BEFORE DELETE ON "lo_test" FOR EACH ROW EXECUTE PROCEDURE "lo_test_del" (); when you run 'delete from lo_test where id = 1' the large object will be deleted in cascade. regards Danny Chen [EMAIL PROTECTED]

[SQL] how to r/w blob field in php

hi, everyone I decide to use text field to store large text but pgsql has 8k limit in insert statement. I have read the sample of create large object of pg_sql in the php manual. here it is: Example 1. Using Large Objects 1 2 13 I am confused. According this sample, but which t

[SQL] generic return for functions

thout having to define all the columns when I call the function? {i.e. without the need to do: select * from myfunction() as (column1 type1, column2...);} If there is such method? It will allow me to maintain the application much easier and makes the conversion task much easier :) Thanks. /Danny _

Re: [SQL] [postgres] Antwort von Microsoft auf Mail hier!

Ja, sone Mail habe ich auch mal bekommen.. da ist wohl was zwischen MS und Yahoo im Busch ... Gruß, Danny Am Mon, 13 Oct 2003 14:18:41 +0200 hat Alvar Freude <[EMAIL PROTECTED]> geschrieben: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Hallo allerseits, > >

[SQL] [postgres] Copy Timestamp NULL

Es geht ebenfalls nicht, wenn ich an der entsprechenden Stelle NULL schreibe. Was muss ich also angeben, damit ich solch eine Datei laden kann ? Viele Grüße, Danny -- Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/ Wenn Sie Ihr Abonnement fuer diese Gruppe kuendige