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