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
| > "WHER
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'
>
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