Thanks, I have "reworded" the email (replaced "transaction" with
"purchase"). The email has now been sent to the pgsql-sql mailing list.
Craig Ringer wrote:
Allan Kamau wrote:
Hi all,
I have a plain sql problem (didn't know where else to post it).
pgsql-sql
I have a list of transactions (market basket) ...
Your use of the term "transaction" for a database entity is really
confusing, and will make it significantly harder for others to
understand and work with your schema. It might be worth renaming the
entity to avoid the conflict with the meaning of "transaction" as
"atomic unit of work" as controlled by BEGIN/COMMIT/ROLLBACK .
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general