Hello, I am attempting to build an xml representation of any database, but
I'm having trouble doing so. I was interested in using the existing xml
functions, such as "schema_to_xmlschema", but the results are strange and
unusable. The resulting schema doesn't even contain the column names, though
i
On Sat, Jun 6, 2009 at 8:30 AM, Richard Broersma wrote:
> On Sat, Jun 6, 2009 at 12:10 AM, Gianvito Pio
> wrote:
>
> > That value doesn't have to be fixed, but I want to define it in a
> > way that it changes its structure when the sensor type changes. For
> > example, for Temperature sensor I w
On Sat, Jun 6, 2009 at 12:10 AM, Gianvito Pio wrote:
> That value doesn't have to be fixed, but I want to define it in a
> way that it changes its structure when the sensor type changes. For
> example, for Temperature sensor I would like to have just a float number,
> but for the humidity I could
Mhm...maybe. I need that thing for just 1 table... Have you seen the Oracle
example? Do you know if I can do a similar thing in PostgreSQL?
- Original Message -
From: "Jasen Betts"
Newsgroups: gmane.comp.db.postgresql.sql
To:
Sent: Saturday, June 06, 2009 2:04 PM
Subject: Re: [SQL] T
On 2009-06-06, Gianvito Pio wrote:
> --001485f44bfe3e357c046ba8b3d6
> Content-Type: text/plain; charset=ISO-8859-1
> Content-Transfer-Encoding: 7bit
>
> Oh that was just an example...Let me make a real example:
> I have a table "Sensors" (that has to contain different sensor types) with
> a Value
Oh that was just an example...Let me make a real example:
I have a table "Sensors" (that has to contain different sensor types) with
a Value. That value doesn't have to be fixed, but I want to define it in a
way that it changes its structure when the sensor type changes. For
example, for Temperatur
