On 2014-03-14, 2:09 AM, liliwow wrote:
Please quick help, because I'm in a fix
1 Tables: mounted device, the elements included in the devices, the link
elements with devices (including the number of elements in the device),
installation steps.
2 The counting of the number of elements needed to perform the contract
assembly of a certain number of devices (eg, 100 units of computers in the
configuration 1).
Generally speaking, generic assembly-of-parts queries, eg how many X do I need
to make a Y, this tends to be recursive and so you probably want to use a WITH
RECURSIVE somewhere in your query; such as that is what lets you do this query
without having to write procedural code or a query that only works for a
specific number of levels. -- Darren Duncan
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
