On 07/05/2013 12:29 AM, giozh wrote:
so thanks to all for the answers. But i'm going to be frustrated, no one of your solutions seems to work, and i can't understand why, because i've write another two functions that works well... I always obtain error: or unknown function (if i pass args without ' ') or "column not exist".
So does it work if you quote the table_name and table_column names? Have you changed the data type to varchar?
i've noticed that on my postgres server, there's two database: one i've created for my scope, and another named postgres (i think created by default). Maybe should i specify on wich database my function should work (also if function compare only inside my personal database)?
Functions are created per database, To be more precise per schema in a database. Functions can be overloaded, so it is possible there is more than one in your database.
To check do the following from the psql propmpt: \df check_if_if_exist
-- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
