[GENERAL] Efficiently selecting single row from a select with window functions row_number, lag and lead

e the query as a single select and if so how? Thanks in advance Andrew Bailey

Re: [GENERAL] Too easy to log in as the "postgres" user?

; > Thom Brown > Crawley, UK > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Andrew Bailey (312) 866 9556 NOTA DE CONFIDENCIALIDAD Y DE NO DIVULGACIÓN:

Re: [GENERAL] How ad an increasing index to a query result?

gresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Andrew Bailey (312) 866 9556 NOTA DE CONFIDENCIALIDAD Y DE NO DIVULGACIÓN: La información contenida en este E-mail y sus archivos adjuntos es confidencial y sólo puede ser util

[GENERAL] 3d Vector Types and operators

Hi, I cant find in the documentation support for a 3 dimensional vector, I have only seen the array type, I am interested in doing vector dot products and vector cross products, also summing vectors and multiplying by a scalar quantity select array[1,2,3]+array[2,4,5]; select 2*array[1,2,3]; The