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 по дате отправления: