Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]

1998-07-21 Thread Bruce Tong
> OK, let's discuss this. How does this affect us? With all three > releasing around the same time, they really dilute themselves. I can't > imagine most people trying more than one of the commercial alternatives. I offer myself up as a case study... I will likely use Oracle (or one of the ot

Re: [GENERAL] Can I store bitmap graphics in a table?

1998-07-21 Thread Dan Delaney
On Tue, 21 Jul 1998, Matt McClure wrote: > You can insert the graphic file by declaring the type to be OID and using > lo_import(). That sounds like it might work. I'll give it a try. However, the graphics I'm going to be inserting are not very large, like 50 to 100k, I'd like to be able to do i

[GENERAL][SQL] Functions with composite resutl-set

1998-07-21 Thread Herve Lefebvre
Hi all, I've a function who retrieves multiple columns: CREATE FUNCTION myfunc() RETURNS SETOF mytable AS 'SELECT a,b,c FROM mytable;' LANGUAGE 'sql'; When I call it, I cannot retrieve all columns without executing 3 times the function. select myfunc() does not work select a(myfunc()), b(myf

[GENERAL] [SQL] Can I store bitmap graphics in a table?

1998-07-21 Thread Dan Delaney
Hello all, Can a bitmap graphic file (say a GIF, JPEG, or EPS) be stored into a PostgreSQL table? If so, how? What field type should I set up in the table and how do I insert the graphic file? Thanks. --Dan --- Daniel G.

[GENERAL] Postgres superuser priviledges

1998-07-21 Thread Konstantinos Vassiliadis
Hi I am new to Postgres. I am trying to load a C function in Postgres under Red Hat Linux. I compile using gcc -I$PGROOT -I$PGROOT/include -I$PGROOT/src/include -c phone.c to produce the object file 'phone.o' Then I link using ld -Bdynamic -o phone.so phone.o -lc to produce the shared object 'p

[GENERAL] Do you receive my e-mail ?

1998-07-21 Thread Przemyslaw Bak
Hi, I sent a few e-mail's to the discussion list but I havent't got any response. Could you tell me if you received any of my e-mail's (I asked about inner and outer join). Regards przemol