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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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