Greg Stark escribió: > On Wed, Nov 25, 2009 at 1:03 AM, Konstantin Izmailov <pgfizm@xxxxxxxxx> wrote: > > > My question: can pg_attribute.attnum be used to determine the sequential > > ordinal positions of columns in a table? What is a right way to get the > > ordinal numbers? > > You could use something like: > > row_number() over (partition by T.schemaname,T.viewname order by > attnum) as "ORDINAL_POSITION" Should we recast the attributes and columns views in information_schema? I notice they still use attnum. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
