select within a fucntion

Sinuhi Arroyo wrote:

I`mtrying to make a select which envolves two tables with in a
function....if 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 unexpected query in exec_stmt_execsql.
If anyone knows how to fix it, it woul be great.
Thanx

What should this "select count(*) from xx;" be good for, if
you don't want to use the result? You can of course do
"perform select ..." because that'd use another PL/pgSQL
executor construct that doesn't complain about getting an
unused return value, but I still wonder why you want to waste
CPU and IO (bought an oversized system?).

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

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 that this was a waste of time), I just wrote a select statement which
by the way, trows the same exception.
Thanks

"Jan Wieck" <janwieck@Yahoo.com> escribi� en el mensaje
news:200101191947.OAA07997@jupiter.jw.home...

"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 error that made it into a SELECT statement
(which SELECT .. INTO is not)

but to make it easier to understand (I now see you were so
smart that this was a waste of time), I just wrote a select statement which
by the way, trows the same exception.

when writing for help or to report a bug, _always_ include the _actual_
code that misbehaves not some other code. I just confuses people.

------------------
Hannu