Everything should have an id, and combination tables like person-gene should
have the person id + the gene id.
You might look at this tool to make your life easier:
https://github.com/pgmodeler/pgmodeler
First, read up on this:
http://en.wikipedia.org/wiki/Entity%E2%80%93relationship_model
then,
I like this one too:
http://mogwai.sourceforge.net/erdesignerng.html
It does reverse engineering, but if you are creating a new model, that
capability is not a necessity.
Mogwai is not Postgresql specific, so you can use it with any db.
-Original Message-
From: Dann Corbit
Sent:
Everything should have an id, and combination tables like person-gene should
have the person id + the gene id.
You might look at this tool to make your life easier:
https://github.com/pgmodeler/pgmodeler
First, read up on this:
http://en.wikipedia.org/wiki/Entity%E2%80%93relationship_model
On 29/03/13 23:32, Gavan Schneider wrote:
Some people wrote:
... Hmm... This should optionally apply to time.
... for anything that really matters, I'll work with UTC.
Is there a Godwin's law http://en.wikipedia.org/wiki/Godwin's_law
equivalent for when our conversations end up with
Hi,
If I have understood well
You have two options:
1. Person_gene (person_id pk, gene_id int)
Genes (gene_id serial pk, gene_type int)
Then for each gene_type separate table with gene_id int what is pk and
relates to genes... And other columns what describe that type...
On Mar 30, 2013, at 3:38, Modulok modu...@gmail.com wrote:
List,
I have a data modeling problem. That much, I know. The question is how do I
model this? (Below.)
I'm making a database which will store pseudo-genetic data. It's a basic
many-to-many setup::
create table person(
Interesting discussion.
The comparisons with timezones ends when it comes to exchange rates.
The rate at the time of transaction has to the stored (somewhere)
associated with the base value. Timezones are rather fixed.
+1
No way can be solved just by type
On Saturday, March 30, 2013,
On Fri, 29 Mar 2013 23:32:20 +1100
Gavan Schneider pg-...@snkmail.com wrote:
Is there a Godwin's law
I am formulating Cain's Law. Something like If a discussion lasts
long enough, someone will mention Godwin's Law.
:-)
--
D'Arcy J.M. Cain da...@druid.net | Democracy is three wolves
On Sat, 30 Mar 2013 20:36:22 +1100
Julian temp...@internode.on.net wrote:
The comparisons with timezones ends when it comes to exchange rates.
The only comparison I made with time and time zones was in how the
column type can be refined when it is created.
With a current WIP. I'm starting to
On Fri, 29 Mar 2013 17:23:50 -0700
Jeff Davis pg...@j-davis.com wrote:
Why not have various rounding functions that do exactly what you want?
Then you can use them anywhere you want in an expression.
Perhaps but the languages that we use all have the capability to manage
this and we will
On Sat, 30 Mar 2013 12:04:21 +1100
Gavan Schneider pg-...@snkmail.com wrote:
No MONEY column would be complete without the ability to specify
whether it is normally DEBIT or CREDIT (or in my preferred case
That seems extreme. What use case would there ever be for making a
column always debit
Thanks a lot.
On Fri, Mar 29, 2013 at 10:22 PM, John R Pierce pie...@hogranch.com wrote:
On 3/29/2013 11:13 AM, John R Pierce wrote:
there is no 'cron' built into postgresql.
actually, there is pgAgent, which is associated with the pgAdmin package,
this implements a cron-like facility to
On 2013-03-29, Gavan Schneider pg-...@snkmail.com wrote:
Some thoughts.
The current MONEY type might be considered akin to ASCII.
Perfect for a base US centric accounting system where there are
cents and dollars and no need to carry smaller fractions. As
discussed, there are some details
Martijn van Oosterhout developed tagged types back in 2005, looks like
it went nowhere. You can search for it, it was pretty interesting.
--
Álvaro Herrerahttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training Services
--
Sent via pgsql-general mailing
unsubscribe
On Fri, Mar 29, 2013 at 10:54 AM, Yuriy Rusinov yrusi...@gmail.com wrote:
Hello colleagues !
I have to write pl/pgsql function that has to be triggered not
before/after insert, but in definite time. Does postgresql allows to do
this ?
Thanks a lot.
--
Best regards,
unsubscribe
On Wed, Mar 27, 2013 at 3:12 PM, Steve Crawford
scrawf...@pinpointresearch.com wrote:
In contrast to certain other open-source databases, PostgreSQL leans
toward protecting data from surprises and erroneous input, i.e. rejecting a
date of 2013-02-31 instead of arbitrarily
unsubscribe
On Fri, Mar 29, 2013 at 10:54 AM, Yuriy Rusinov yrusi...@gmail.com wrote:
Hello colleagues !
I have to write pl/pgsql function that has to be triggered not
before/after insert, but in definite time. Does postgresql allows to do
this ?
Thanks a lot.
--
Best regards,
On 03/30/2013 08:42 PM, ajmcello wrote:
unsubscribe
If you want to unsubscribe:
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
18 matches
Mail list logo