Re: Help with SQL Function

Simpler than you think:
select count (*) from dedcolo where equip_type = $1

(note the space between = and $)


On Wed, 3 Jan 2001, Jeff Eckermann wrote:

> I'm falling at the first hurdle.  Can someone tell me how to pass an
> attribute value into a function, as I'm trying to do below?  I've studied
> the docs every which way, but can't seem to find the cause of my problem.
> Thanks in advance for ignorance relief.
>
> extracts=# create function testfunc(text) returns int4 as '
> extracts'# select count (*) from dedcolo where equip_type = ''$1''    ---
> That's doubled single quotes
> extracts'# ' language 'sql';
> CREATE
> extracts=# select testfunc('Dialup');
>  testfunc
> ----------
>         0
> (1 row)
> extracts=# create function testfunc() returns int4 as '
> extracts'# select count (*) from dedcolo where equip_type = ''Dialup''   ---
> Doubled single quotes, again
> extracts'# ' language 'sql';
> CREATE
> extracts=# select testfunc();
>  testfunc
> ----------
>      3453
> (1 row)
>
>