Skip site navigation (1) Skip section navigation (2)

select from table

From: Kovacs Zoltan Sandor <tip(at)pc10(dot)radnoti-szeged(dot)sulinet(dot)hu>
To: pgsql-sql(at)postgresql(dot)org
Subject: select from table
Date: 2000-06-29 16:56:55
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
I would like to do something like this:

create function x(varchar) returns setof int4 as
'select * from $1;' language 'sql';

Unfortunately, the parser drops me back: I cannot use any parameters after
the keyword "from". How to solve this? A solution in PL/PgSQL would be
also nice.

Thanks in advance, Zoltan

pgsql-sql by date

Next:From: Schlobohm, JackDate: 2000-06-29 21:33:19
Subject: error 3122 in ACCESS -
Previous:From: Jochen SchmidtDate: 2000-06-29 13:58:22
Subject: isnull or coalesce isn't working

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group