table name in pl/pgsql
| От | ON.KG |
|---|---|
| Тема | table name in pl/pgsql |
| Дата | |
| Msg-id | 15933163937.20041125194221@on.kg обсуждение |
| Ответ на | Re: Benchmark-Comparison PostGreSQL vs. SQL Server (Richard Huxton <dev@archonet.com>) |
| Ответы |
Re: table name in pl/pgsql
Re: table name in pl/pgsql Re: table name in pl/pgsql |
| Список | pgsql-general |
New question:
i have tables like
table_20041124,
table_20041125,
etc...
i'm trying to make function (for example):
=====================================
CREATE FUNCTION get_count(text, text)
RETURNS int2 AS '
DECLARE
cnt int4;
BEGIN
SELECT INTO cnt COUNT(*)
FROM table_$1 -- That doesn't work
WHERE key = $2;
RETURN cnt;
END;'
LANGUAGE 'plpgsql';
=====================================
call this function by:
=====================================
SELECT get_count("20041124", "something");
=====================================
string in funstion - FROM table_$1
how could i get a final correct table name here?
Thanx!
В списке pgsql-general по дате отправления: