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

1998-07-22 Thread Herve Lefebvre
---Bruce Tong <[EMAIL PROTECTED]> wrote: > > features != ANSI SQL compliance, right? > > I suppose ANSI SQL is the heart of it. > > > Again, what are we missing that Oracle currently has...? > Stored procedures with tuples resultset: SELECT F1,F2,F3 FROM TABL1 And Multi-resultsets stored-pro

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

1998-07-22 Thread Herve Lefebvre
> You want an honest answer? We don't. Or, at least, we don't > think of it as meeting a challenge. I agree, I think it's a bad news for Sybase, but a very good news for Linux. And if it's good for Linux, it's good for pgsql. -- Herve Lefebvre _

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

1998-07-21 Thread Herve Lefebvre
rk select a(myfunc()), b(myfunc()), c(myfunc()) works but executes 3 times the function. I've tried select *(mynfunc()) select all(myfunc()) select myfunc()::mytable select myfunc()::mytable.* ... But i've a syntax error on each of these. An