Re: [HACKERS] select within a fucntion

2001-01-24 Thread Sinuhé Arroyo Gómez
The thing is that I´m not interested in wasting CPU nor my ystem is oversized, and of course, "my friend", I willl use the results of the select, because as a matter of fact it was a select .. into statement the one I was trying, but to make it easier to understand (I now see you were so smart

Re: [HACKERS] select within a fucntion

2001-01-24 Thread Hannu Krosing
"Sinuh Arroyo Gmez" wrote: The thing is that Im not interested in wasting CPU nor my ystem is oversized, and of course, "my friend", I willl use the results of the select, because as a matter of fact it was a select .. into statement the one I was trying, There was probably a syntax error

[HACKERS] select within a fucntion

2001-01-19 Thread Sinuhé Arroyo
I`mtrying to make a select which envolves two tables with in a functionif the query is written this way: (this is just an example, not my query) a := (select count(*) from xx); it works fine, but if I type the query like this select count(*) from xx; it throws a message that says