Re: [GENERAL] Can't put sub-queries values in queries results?

2000-07-23 Thread Manuel Lemos
Hello Andrew, On 23-Jul-00 01:29:37, you wrote: >> >What about defining a function for the sub-query: >> >> >CREATE FUNCTION count_subs( INT4 ) RETURNS INT4 AS ' >> >SELECT COUNT(*) FROM t2 WHERE t2.f2=$1; >> >' LANGUAGE 'SQL'; >> >> >Then you should be able to: >> >> >SELECT f1, count_subs(f

Re: [GENERAL] Can't put sub-queries values in queries results?

2000-07-23 Thread Manuel Lemos
Hello Jan, On 22-Jul-00 20:03:39, you wrote: >> >What version are you using? >> >Current sources allow this, and 7.0.2 should as well. >> >> I am using 6.4 . I wanted to use earlier versions but they require a >> larger shared memory (1MB I suppose) than it is available on my ISP >> machine. >