Re: SQL For smarties - Mailing list pgsql-sql

From Graham Vickrage
Subject Re: SQL For smarties
Date
Msg-id NDBBJABDILOPAOOMFJHOGEAMDEAA.graham@digitalplanit.com
Whole thread Raw
In response to Re: SQL For smarties  (Rajesh Kumar Mallah <mallah@trade-india.com>)
Responses Re: SQL For smarties  (Jeff Eckermann <jeff_eckermann@yahoo.com>)
Re: SQL For smarties  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-sql
I am trying to create tables from within a funtion i.e.

create function _tree_create(text) retuns int as '
begin;
create table $1_tree (....);
return 1;
end;
...

select _tree_create('item');

An error message refering to $1 gets thrown up. Is this not possible to do
or is there another way of doing it?

Thanks in advance.

Graham




pgsql-sql by date:

Previous
From: clayton cottingham
Date:
Subject: Re: comparision chart
Next
From: Jeff Eckermann
Date:
Subject: Re: SQL For smarties