no pb: I am french, so quite skilled on that topic :-)
there is only 50 bottles of various malt on the presentoir close to my desk
so I must stay reasonnable :-)
Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com
On Thu, Jun 3, 2021 at 11:17 PM Adrian Klaver
wrote:
> On 6/3/21 1:01 PM
On 6/3/21 1:01 PM, Marc Millas wrote:
thanks Adrian, exactly what I was missing :-)
about knowing if I should...
We have to create a set of triggers (insert, update, delete) within a
huge set of tables. and that list of tables, and structure of them can
be customized, maintained, ...
so we we
I know it would be non-standard, but I would love to see Postgres support the
likes of nested functions.
I know that would be non-standard, but Postgres has lots of non-standard
features that make it more like a real programming language and considerably
more productive.
On Jun 3, 2021, 12:34 -
I take note of this.
thanks
Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com
On Thu, Jun 3, 2021 at 10:23 PM David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Thu, Jun 3, 2021 at 1:02 PM Marc Millas wrote:
>
>> about knowing if I should...
>> We have to create a set of trigg
On Thu, Jun 3, 2021 at 1:02 PM Marc Millas wrote:
> about knowing if I should...
> We have to create a set of triggers (insert, update, delete) within a huge
> set of tables. and that list of tables, and structure of them can be
> customized, maintained, ...
> so we were looking for a standard s
thanks Adrian, exactly what I was missing :-)
about knowing if I should...
We have to create a set of triggers (insert, update, delete) within a huge
set of tables. and that list of tables, and structure of them can be
customized, maintained, ...
so we were looking for a standard script to automa
good reading, thanks
Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com
On Thu, Jun 3, 2021 at 9:21 PM Tom Lane wrote:
> Adrian Klaver writes:
> > On 6/3/21 12:01 PM, Bruce Momjian wrote:
> >> On Thu, Jun 3, 2021 at 08:58:03PM +0200, Marc Millas wrote:
> >>> within a function, I want
On Thu, Jun 3, 2021 at 03:21:15PM -0400, Tom Lane wrote:
> Adrian Klaver writes:
> > On 6/3/21 12:01 PM, Bruce Momjian wrote:
> >> On Thu, Jun 3, 2021 at 08:58:03PM +0200, Marc Millas wrote:
> >>> within a function, I want to create another function.
>
> >> You can't create functions inside of
Adrian Klaver writes:
> On 6/3/21 12:01 PM, Bruce Momjian wrote:
>> On Thu, Jun 3, 2021 at 08:58:03PM +0200, Marc Millas wrote:
>>> within a function, I want to create another function.
>> You can't create functions inside of functions; same for procedures.
> Sure you can:
Yeah. The actual p
On 6/3/21 12:01 PM, Bruce Momjian wrote:
On Thu, Jun 3, 2021 at 08:58:03PM +0200, Marc Millas wrote:
Hi,
within a function, I want to create another function.
no pb.
but if I write:
declare bidule text;
begin
bidule:='myfunc';
create function bidule() ...
it does create a function named bidu
On Thu, Jun 3, 2021 at 08:58:03PM +0200, Marc Millas wrote:
> Hi,
>
> within a function, I want to create another function.
> no pb.
> but if I write:
> declare bidule text;
> begin
> bidule:='myfunc';
> create function bidule() ...
>
>
> it does create a function named bidule and not myfunc.
>
On Wed, Dec 25, 2019 at 09:17:22PM -0800, Adrian Klaver wrote:
> On 12/25/19 4:48 PM, Rob Sargent wrote:
> >
> >
> > > On Dec 25, 2019, at 3:10 PM, stan wrote:
> > > There is more that that. There is a project number, so the actuall key
> > > represents the combination of project number, and c
On 12/25/19 3:09 PM, stan wrote:
On Wed, Dec 25, 2019 at 02:34:43PM -0800, Adrian Klaver wrote:
On 12/25/19 12:39 PM, stan wrote:
Other approaches have been suggested, e.g. use a traditional FK
relationship. The big unknown in you present system is what:
SELECT cost_category_key from t2 w
On 12/25/19 4:48 PM, Rob Sargent wrote:
On Dec 25, 2019, at 3:10 PM, stan wrote:
There is more that that. There is a project number, so the actuall key
represents the combination of project number, and cost category, Thire is a
constraint on T2 that assures that these combinations will be uni
> On Dec 25, 2019, at 3:10 PM, stan wrote:
> There is more that that. There is a project number, so the actuall key
> represents the combination of project number, and cost category, Thire is a
> constraint on T2 that assures that these combinations will be unique.
>
> When the 1st record for
On Wed, Dec 25, 2019 at 06:09:55PM -0500, stan wrote:
> On Wed, Dec 25, 2019 at 02:34:43PM -0800, Adrian Klaver wrote:
> > On 12/25/19 12:39 PM, stan wrote:
> > >
> > > On Wed, Dec 25, 2019 at 11:55:51AM -0800, Adrian Klaver wrote:
> > > > On 12/25/19 11:08 AM, stan wrote:
> > > > >
> > > > > O
On Wed, Dec 25, 2019 at 02:34:43PM -0800, Adrian Klaver wrote:
> On 12/25/19 12:39 PM, stan wrote:
> >
> > On Wed, Dec 25, 2019 at 11:55:51AM -0800, Adrian Klaver wrote:
> > > On 12/25/19 11:08 AM, stan wrote:
> > > >
> > > > On Wed, Dec 25, 2019 at 08:28:45AM -0800, Adrian Klaver wrote:
> > > >
On 12/25/19 12:39 PM, stan wrote:
On Wed, Dec 25, 2019 at 11:55:51AM -0800, Adrian Klaver wrote:
On 12/25/19 11:08 AM, stan wrote:
On Wed, Dec 25, 2019 at 08:28:45AM -0800, Adrian Klaver wrote:
On 12/25/19 7:26 AM, stan wrote:
I am writing a trigger/function to make certain a default item,
> On Dec 25, 2019, at 11:56 AM, Adrian Klaver <
>> First of all, thanks to both of you for your fast response .
>> Let me clarify.
>> I have a table that records will be inserted into. Several of the columns
>> in this table must be non NULL, and they are actually keys from other
>> tables. Lik
On Wed, Dec 25, 2019 at 11:55:51AM -0800, Adrian Klaver wrote:
> On 12/25/19 11:08 AM, stan wrote:
> >
> > On Wed, Dec 25, 2019 at 08:28:45AM -0800, Adrian Klaver wrote:
> > > On 12/25/19 7:26 AM, stan wrote:
> > > > I am writing a trigger/function to make certain a default item, and its
> > >
On 12/25/19 11:08 AM, stan wrote:
On Wed, Dec 25, 2019 at 08:28:45AM -0800, Adrian Klaver wrote:
On 12/25/19 7:26 AM, stan wrote:
I am writing a trigger/function to make certain a default item, and its key
exist when an insert is called. EG
The trigger gets called on insert to T1 If column c1
On Wed, Dec 25, 2019 at 08:28:45AM -0800, Adrian Klaver wrote:
> On 12/25/19 7:26 AM, stan wrote:
> > I am writing a trigger/function to make certain a default item, and its key
> > exist when an insert is called. EG
> >
> > The trigger gets called on insert to T1 If column c1 is NULL in the NEW
On 12/25/19 7:26 AM, stan wrote:
I am writing a trigger/function to make certain a default item, and its key
exist when an insert is called. EG
The trigger gets called on insert to T1 If column c1 is NULL in the NEW
structure, I need to check table t2 to get the key associated with the
default f
Hi
st 25. 12. 2019 v 16:26 odesÃlatel stan napsal:
> I am writing a trigger/function to make certain a default item, and its key
> exist when an insert is called. EG
>
> The trigger gets called on insert to T1 If column c1 is NULL in the NEW
> structure, I need to check table t2 to get the key a
24 matches
Mail list logo
