gt; Best,
> Oliver
>
> - Original Message - From: "Scott Swank"
> To: "Oliveiros d'Azevedo Cristina"
> Cc: "Abhinandan Raghavan" ;
>
> Sent: Tuesday, December 06, 2011 5:17 PM
> Subject: Re: [SQL] Self-Join
>
>
>
> H
Have you read Tony Andrew's 2004 piece on this approach? It is a classic.
http://tonyandrews.blogspot.com/2004/10/otlt-and-eav-two-big-design-mistakes.html
Scott
On Tue, Dec 6, 2011 at 6:39 AM, Oliveiros d'Azevedo Cristina
wrote:
> Howdy, Abhinandan,
>
> A quick and dirty solution might be this
I would opt for a hybrid of 1 & 3. I imagine that many of your costs
are the same month in, month out. Those I would put in specific
columns, and then retrieve the varying columns from an EAV model.
If you only run invoicing monthly then I'd be tempted to store this
varying EAV structure in a seri
Here is a seeming quirk in pgadmin3. I say seeming, because I may
simply not be sufficiently familiar with this tool.
[A quick note for non-mac users, the Finder is the gui file browser,
equivalent to Nautilus/Dolphin in linux or the Window Explorer in MS
Windows.]
I have associated sql files wit
Thanks all. I'd tried pgadmin3 and perhaps moved on too quickly. On
2nd look it's better than I'd initially considered.
Cheers,
Scott
On Wed, Oct 19, 2011 at 1:13 AM, Basil Bourque wrote:
>>> I have a postgres 9.1 database up & running, no problem. Purely in
>>> terms of writing sql (ddl, dml &
I have a postgres 9.1 database up & running, no problem. Purely in
terms of writing sql (ddl, dml & pg/plsql), what tools are
recommended?
Coming from an Oracle world, I'm thinking of toad, sql developer, etc.
1. psql & text editor of choice (if so, which one?)
2. navicat
3. textmate with pgedit
