Help with SQL Function
| От | Jeff Eckermann |
|---|---|
| Тема | Help with SQL Function |
| Дата | |
| Msg-id | 08CD1781F85AD4118E0800A0C9B8580B09486F@NEZU обсуждение исходный текст |
| Ответы |
Re: Help with SQL Function
|
| Список | pgsql-general |
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)
В списке pgsql-general по дате отправления: