Re: [HACKERS] select within a fucntion

2001-01-24 Thread Hannu Krosing
"Sinuhé Arroyo Gómez" wrote: > > 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, There was probably a syntax

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 tha

Re: [HACKERS] select within a fucntion

2001-01-19 Thread Jan Wieck
Sinuhi Arroyo wrote: > 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; > >

[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 unexpecte