| From: | Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: postgresql vs mysql |
| Date: | 2007-02-23 01:53:25 |
| Message-ID: | 45DE4915.8010209@cox.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 02/22/07 19:04, Mark Walker wrote:
> I'm not sure what you're trying to do but, it appears that you database
> design is incorrect. What you need is something like
>
> CREATE TABLE temp_readings
> (
> _date Date,
> temperature double,
> source varchar(20),
> )
>
> No reading, no record. Are you suggesting that you would have a weekly
> set of records for each row?
But you still need NULL/UNKNOWN for outer joins.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
iD8DBQFF3kkVS9HxQb37XmcRAv7yAJ9Py3X/WGt+qe7R8WF1zyFIO38tNQCfZBaN
GCWtuQ48h1dh5eTL5TSv0cA=
=oFIk
-----END PGP SIGNATURE-----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2007-02-23 02:46:07 | Re: Wikipedia on Postgres (was Re: postgresql vs mysql) |
| Previous Message | Joshua D. Drake | 2007-02-23 01:21:59 | Re: Wikipedia on Postgres (was Re: postgresql vs mysql) |