select within a fucntion - Mailing list pgsql-hackers

From Sinuhé Arroyo
Subject select within a fucntion
Date
Msg-id 3A684EAD.C6060D5A@isoco.com
Whole thread Raw
Responses Re: select within a fucntion  (Jan Wieck <janwieck@Yahoo.com>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: install locale.
Next
From: Tom Lane
Date:
Subject: Re: Re: Getting configure to notice link-time vs run-time failures