Skip site navigation (1) Skip section navigation (2)

Re: Flattening a kind of 'dynamic' table

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Dawid Kuroczko <qnex42(at)gmail(dot)com>
Cc: Alexandre Leclerc <alexandre(dot)leclerc(at)gmail(dot)com>,PERFORM <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Flattening a kind of 'dynamic' table
Date: 2005-01-27 16:41:15
Message-ID: 41F919AB.5070901@familyhealth.com.au (view raw or flat)
Thread:
Lists: pgsql-performance
> Unfortunately we will need a rowtype with all the departaments:
> CREATE DOMAIN departaments AS (a int, b int, c int, d int, ...);

I think you mean CREATE TYPE departments...

Chris

In response to

pgsql-performance by date

Next:From: PFCDate: 2005-01-27 16:44:15
Subject: Re: [SQL] OFFSET impact on Performance???
Previous:From: Dawid KuroczkoDate: 2005-01-27 16:27:40
Subject: Re: Flattening a kind of 'dynamic' table

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group