From: Gene Selkov Jr. <selkovjr@mcs.anl.gov>
To: pgsql-sql@postgreSQL.org
Subject: Re: [SQL] CREATE TABLE (fwd ): again! owner-pgsql-sql@postgreSQL.org: BOUNCE pgsql-sql@postgreSQL.org
Date: Fri, 05 Mar 1999 16:49:34 -0500
Message-ID: <199903052247.QAA20078@antares.mcs.anl.gov> (raw)
In-Reply-To: <Pine.GSO.3.96.990305150731.7678D-100000@isis>
> Hello all!
>
> I beleive that somebody knows how to answer my question...please!!
I think the reason you are not getting an (immediate) answer from the
list is that you appear to be exploring the stuff that has been pretty
much abandoned since postgres95, not because we are insensitive barbarians
with disrespect for newbies ;)
There are still some areas in postgres about which people just can't
speak with confidence.
> Make me a favor, please: Im going to send to you what I did, can you see
> that and tell me what could be bad?!.
>
> The example is:
>
>
> ---------------------------------------------------------
> CREATE TABLE emp (code INT4
> , name VARCHAR(20)
> , salary INT4
> , 2salary INT4 default double_salary(emp)
> );
>
> CREATE FUNCTION double_salary(emp) RETURNS INT4
> AS 'SELECT $1.salay * 2 AS result' LANGUAGE 'sql'
> ;
As I understood your intent, you want the value of 2salary (BTW,
2salary would not be a valid identifier) to be twice the value of the
other attribute by default. The problem here is that $1.salay (watch
typos!) refers to the whole salary column, not to its value in the row
you are inserting. There is no way to let the function know what the
'current' row is.
If I where you, I would set a rule or a trigger, or simply run a query like this:
UPDATE emp SET salary2 = salary * 2 FROM emp WHERE salary2 ISNULL;
> Function double_salary receives an 'emp' , as you see, and there is the
> error, because if I change parameter 'emp' by a number, the error doesn't
> appear.
The current syntax does not obviously allow identifiers here. There is
probably no use for identifiers in this context, anyway. It is
normally used with constants, such as:
DEFAULT nextval('default_seq'));
> The origin of this question is that I want to know if a subclass inherits
> all attributes from the parent, included functions like double_salary in
> my example.
Attributes or functions? Functions do not belong within classes and
therefore cannot be inherited. You should view functions as
stand-alone entities. Only attributes are inherited, and it is hard to
say to what degree the inheritance mechanism remained functional in
the course of development. Since no one seems to use it, your best
source of information (other than the postgres source code and
original developers themselves) would be the files in src/test/regress
--Gene
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: selkovjr@mcs.anl.gov
Subject: Re: [SQL] CREATE TABLE (fwd ): again! owner-pgsql-sql@postgreSQL.org: BOUNCE pgsql-sql@postgreSQL.org
In-Reply-To: <199903052247.QAA20078@antares.mcs.anl.gov>
References: <Pine.GSO.3.96.990305150731.7678D-100000@isis> <199903052247.QAA20078@antares.mcs.anl.gov>
* 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