subject:"\[SQL\] Table name as a variable in SELECT query"

Re: [SQL] Table name as a variable in SELECT query

2010-12-18 Thread Andreas Kretschmer

Andrey Fokin wrote: > Hi, > please advise is possible in SELECT query use variable as a table name? > > I would like to have for example something like: > > CREATE OR REPLACE FUNCTION test_name (tb varchar) RETURNS int AS $$ > > DECLARE > > .. > > BEGIN >

[SQL] Table name as a variable in SELECT query

2010-12-18 Thread Andrey Fokin

Hi, please advise is possible in SELECT query use variable as a table name? I would like to have for example something like: CREATE OR REPLACE FUNCTION test_name (tb varchar) RETURNS int AS $$ DECLARE .. BEGIN SELECT * FROM $1;