On Fri, 8 Dec 2006, Tom Lane wrote:
Marc Evans <[EMAIL PROTECTED]> writes:
I am trying to make use of table partitions. In doing so I would like to
use a rule to call a functioning which inserts the data into the proper
partition.
Basically, you're guaranteeing yourself large amounts of pain
Marc Evans <[EMAIL PROTECTED]> writes:
> I am trying to make use of table partitions. In doing so I would like to
> use a rule to call a functioning which inserts the data into the proper
> partition.
Basically, you're guaranteeing yourself large amounts of pain by
insisting on using a rule for
Hi -
I am trying to make use of table partitions. In doing so I would like to
use a rule to call a functioning which inserts the data into the proper
partition. To do so, I believe that I need to find a way to opaquely pass
NEW from the rule to a function which then passes it to INSERT. (Well,
Stephan Szabo wrote:
>
> > but I received this as the error:
> > --
> > ERROR: Unrecognized language specified in a CREATE FUNCTION:
> > 'plpgsql'. Recognized languages are sql, C, internal and the
> > created
> > procedural languages.
> >
> but I received this as the error:
> --
> ERROR: Unrecognized language specified in a CREATE FUNCTION:
> 'plpgsql'. Recognized languages are sql, C, internal and the
> created
> procedural languages.
>
Hi All,
I'm trying to create a function that takes an interval (in seconds)
and
returns HH:MM:SS similar to reltime() but not dividing down to num#
days,months etc...
anyway, I've been looking into the CREATE FUNCTION routines and
here I
struck a stumbling block.
I tried(from the doco):
