Re: Help with trigger - Mailing list pgsql-general

From Michael Satterwhite
Subject Re: Help with trigger
Date
Msg-id 201101061044.29974.michael@weblore.com
Whole thread Raw
In response to Help with trigger  (Michael Satterwhite <michael@weblore.com>)
List pgsql-general
On Monday, December 27, 2010 03:36:35 pm you wrote:
> Michael Satterwhite <michael@weblore.com> writes:
> > On Monday, December 27, 2010 12:58:40 pm Guillaume Lelarge wrote:
> >> Le 27/12/2010 18:57, Michael Satterwhite a écrit :
> >>> I'm obviously missing something ... and probably something obvious. Why
> >>> is date2 still null?
> >>
> >> I'm not sure it'll help you. I copy/pasted your SQL script in my 9.0.2
> >> release. Worked great.
> >
> > I'm running 8.4.2.
>
> Well, as somebody already pointed out, the example you posted works
> fine.  When I try it in 8.4.6, I get
>
> # select * from test;
>         date1        |        date2
> ---------------------+---------------------
>  2012-05-04 00:00:00 | 2012-04-27 00:00:00
> (1 row)
>
> I find it interesting that your quoted result is
>
> # select * from test;
>         date1        | date2
> ---------------------+-------
>  2012-04-27 00:00:00 |
> (1 row)
>
> What it looks like from here is there's a typo in the actually-executing
> version of the function, such that date1 not date2 is assigned the
> week-old date value.  Perhaps "\df+ t_listing_startdate" would get
> you started towards sorting it out.

You nailed it. I found what was happening - and it works (as everyone said it
should). I apologize for not seeing the obvious!

Thanks to everyone!

pgsql-general by date:

Previous
From: Anthony
Date:
Subject: Re: UUID column as pimrary key?
Next
From: Chris Browne
Date:
Subject: Re: UUID column as pimrary key?