Re: in query variables....

>
> Hi all,
>
> this is from the is there a way file.
> Is there a way to get the name of the relation or relations in a query
> from within the query?  Like some kind of magic variable...?
> for example :
>               "select *,  from thistable"
> where  would be replaced by thistable.
>
>
> Rhys
> Peace & Love|Live Long & Prosper
>

No as far as I know, but you can create a stored procedure and pass
as parameter the table and then "create" your own query and
execute it from within the stored procedure

http://www.postgresql.org/docs/8.2/static/plpgsql-statements.html

EXECUTE 'UPDATE '|| some_magic_variable || ' SET '
        || quote_ident(colname)
        || ' = '
        || quote_literal(newvalue)
        || ' WHERE key = '
        || quote_literal(keyvalue);

I haven't tried it thought.
_________________________________________________________________
Tenemos lo que búscas…JUEGOS.
http://club.prodigymsn.com/