From: Martin Knipper <knipper@mk-os.de>
To: pgsql-sql@postgresql.org
Subject: Re: Function valid only for one table
Date: Wed, 19 May 2004 19:09:35 +0200
Message-ID: <40AB94CF.90802@mk-os.de> (raw)
In-Reply-To: <40AB8C4C.8080602@archonet.com>
References: <40AB7272.2090605@mk-os.de>
<40AB8C4C.8080602@archonet.com>
Am 19.05.2004 18:33 schrieb Richard Huxton:
> Martin Knipper wrote:
>
>>Hi there,
>>
>>is it possible to define a function that is only valid in a context
>>of one table ?
>>
>>For Example:
>>
>>select someFunction() from someTable;
>>-> OK
>>
>>select someFunction() from anotherTable;
>>-> Error: someFunction unkown
>
>
> Um, no. What do you want someFunction() to do?
>
I thought about a mixture of object orientation and a normal table
for a relational database.
someFunction() is a method for the object/table someTable.
Since AFAIK postgres doesn't support calling methods of types or
objects I thought about a workaround. That's why is ask the above
question.
By the way, does anyone know if there is something like a standard
for object relational databases ? An URL would be nice.
Thanks and Greetings,
Martin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: knipper@mk-os.de
Subject: Re: Function valid only for one table
In-Reply-To: <40AB94CF.90802@mk-os.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox