Re: Passing table names to PL/PGSQL for SELECT/UPDATE/INSERT

Unfortunately, PL/PGSQL cannot pass table name.
I have same problem, only thing I can do is pass an integer, then use IF
.. THEN .. ELSE .. END IF;


Jie LIANG

St. Bernard Software

10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873

jliang@ipinc.com
www.stbernard.com
www.ipinc.com

On Sat, 3 Mar 2001, Gerald Gutierrez wrote:

> 
> I've written my Dijkstra's algorithm in PL/PGSQL. It didn't turn out to be 
> a big deal at all actually, programming-wise. I understand execution speed 
> will be poor but it shouldn't be any slower than having something else, 
> like PHP or Java, execute logic and query the database.
> 
> I'd like to generalize my function. As per Richard Huxton's suggestion to 
> create tables named after session ID (thanks Richard)s, I'd like to pass in 
> some table names so that the algorithm can read from and write into tables 
> that I specify as parameters to the function. Sometihng like:
> 
> select dijkstra(inputtablename, outputtablename);
> 
> I've tried typing the parameters as TEXT, and then just inserting $1 in the 
> select (e.g. SELECT * from $1 ...) This doesn't work, nor did a number of 
> other ways I tried.
> 
> How can this be done?
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>