Re: [GENERAL] Getting one row for each subquery row...?

[Dennis Gearon]

First off, I've nerver heard of using Floating point for money. There 
**IS** rounding and truncation that goes on, in even double precision. 
The bean counters get upset if you lose .0000001 dollars, especially if 
it occurs for several million transactions. The usual choice is DECIMAL.

And I'd use some sort of DATE or TIMESTAMP for the date. and time values.

since you didn't supply any notes, it would be easier to understand if 
you used foreign key constraints, and a sounder design perhaps.

And so that I can understand my own queries, I indent them etc(postgres 
cares not):

select
   t_stockchanges.productid,
   (select 
       name from t_productgroups
   where id=
       (select 
          productgroupid from t_prod_in_pgr
       where productid=t_stockchanges.productid
       )
   )
as pgroup
from t_stockchanges;

From you table definitions and titles, I assume, 't_prod_in_pgr' is 'product in process'. You are making an assumption that a user (?) web user (?) can only have on line entered in that table at a time?
You will have to explain more about this for me to get it, perhaps for others you will not.

Also, it seems to me that 'productgroupid' should be related to 't_productgroups', but I can not tell.

Tell us more, it gets 'curiouser and curiouser'!



---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend