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: Pine.LNX.4.05.10006291852400.25722-100000@pc10.radnoti-szeged.sulinet.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Browse pgsql-sql by date

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