Postgres Pro
Downloads
Home   >   mailing lists

Table as parameter - Mailing list pgsql-general

From Alex Paulo
Subject Table as parameter
Date
Msg-id 90b77fd70908140525v41315b47j80ed2af14c04f67e@mail.gmail.com
Whole thread Raw
Responses R: Table as parameter  (Scara Maccai <m_lists@yahoo.it>)
Re: Table as parameter  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
List pgsql-general
Tree view
Friends of pgsql-general list,

I have a problem: I need put the "table name" as a parameter in a function!
So, When I write, inside that function, the following code:

SELECT INTO var_resposta SUM(campo) FROM $1
return var_resposta;

Knows that $1 is the table name, the postgres said that this is a sintax error, exactly at $1 position!
Somebody can help me?

Thank you for taking the time!

Best Regards, Alex Paulo.

pgsql-general by date:

Previous
From: Jasen Betts
Date:
Subject: Re: PQoidValue - isn't it for...?
Next
From: Scara Maccai
Date:
Subject: adding a nullable col could rewrite the whole table?