2009/11/17 Adam Rich <ada...@sbcglobal.net>: > Hello, > There is an existing function which takes an integer and returns a record. > I need to call this function with every integer in a table. Is there a > simple shortcut for doing this? > > I'm looking for something like: > > select f.* > from function(t.value) f, table t >
Hello, attention, relation databases isn't spreadsheet. There isn't any shortcut. You can write function based on information_schema.colums that helps with generating SQL statement. Regards Pavel Stehule > Thanks, > Adam > > > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
