Hi,
I've the following function:
CREATE FUNCTION book_info(pricing)
RETURNS catalog_general AS '
select *
from catalog_general
where star_isbn = $1.vista_isbn
' LANGUAGE 'sql';
calling it as:
SELECT p.*, p.book_info.title FROM pricing p WHERE vista_ans='POD';
background
Brent Verner [EMAIL PROTECTED] writes:
calling it as:
SELECT p.*, p.book_info.title FROM pricing p WHERE vista_ans='POD';
background and observation:
the pricing table is fairly large, but only a small number meet
"WHERE vista_ans='POD'". I can select all where vista_ans='POD'
very
On 24 Jan 2001 at 12:14 (-0500), Tom Lane wrote:
| Brent Verner [EMAIL PROTECTED] writes:
| calling it as:
|SELECT p.*, p.book_info.title FROM pricing p WHERE vista_ans='POD';
| background and observation:
|the pricing table is fairly large, but only a small number meet
|"WHERE