On Wed, May 19, 2010 at 12:26:07PM +0400, silly sad wrote:
> On 05/18/10 23:27, Kenneth Marshall wrote:
>
>> It works using 'now' and I assume that since curtime is
>
> now() is NOT the CURRENT timestamp in fact,
> it is about the timestamp of the current transaction has been started.
>
> it is the
On 2010-05-18, Kenneth Marshall wrote:
> I am trying to write a function that updates the
> date column to the current date. According to:
>
> http://www.postgresql.org/docs/8.4/static/functions-datetime.html#FUNCTIONS-DATETIME-CURRENT
>
> you can use CURRENT_DATE. When I try to use it in
> the fo
Brian Modra wrote:
>>> It works using 'now' and I assume that since curtime is
>>> of type DATE that the assignment casts the return automatically
>>> to type DATE. Thank you for the ideas.
>>> [...]
>> What's wrong with Pavel's correct and to-the-point answer?
> No need actually to cast... jus
On 05/18/10 23:27, Kenneth Marshall wrote:
It works using 'now' and I assume that since curtime is
now() is NOT the CURRENT timestamp in fact,
it is about the timestamp of the current transaction has been started.
it is the really USEFUL value, still u have to remember this meaning.
--
Sent
On 19/05/2010, Tim Landscheidt wrote:
> Kenneth Marshall wrote:
>
>> It works using 'now' and I assume that since curtime is
>> of type DATE that the assignment casts the return automatically
>> to type DATE. Thank you for the ideas.
>> [...]
>
> What's wrong with Pavel's correct and to-the-point
Kenneth Marshall wrote:
> It works using 'now' and I assume that since curtime is
> of type DATE that the assignment casts the return automatically
> to type DATE. Thank you for the ideas.
> [...]
What's wrong with Pavel's correct and to-the-point answer?
Tim
--
Sent via pgsql-sql mailing li
Okay, this works as well. Thank you for all of the
assistance.
Regards,
Ken
On Tue, May 18, 2010 at 09:25:00PM +0200, Pavel Stehule wrote:
> 2010/5/18 Richard Broersma :
> > On Tue, May 18, 2010 at 12:08 PM, Kenneth Marshall wrote:
> >
> >> http://www.postgresql.org/docs/8.4/static/functions-dat
To follow-up,
It works using 'now' and I assume that since curtime is
of type DATE that the assignment casts the return automatically
to type DATE. Thank you for the ideas.
Regards,
Ken
On Tue, May 18, 2010 at 12:12:46PM -0700, Richard Broersma wrote:
> On Tue, May 18, 2010 at 12:08 PM, Kenneth
2010/5/18 Richard Broersma :
> On Tue, May 18, 2010 at 12:08 PM, Kenneth Marshall wrote:
>
>> http://www.postgresql.org/docs/8.4/static/functions-datetime.html#FUNCTIONS-DATETIME-CURRENT
>>
>> you can use CURRENT_DATE. When I try to use it in
>> the following pl/pgSQL function it gives the error:
On Tue, May 18, 2010 at 12:08 PM, Kenneth Marshall wrote:
> http://www.postgresql.org/docs/8.4/static/functions-datetime.html#FUNCTIONS-DATETIME-CURRENT
>
> you can use CURRENT_DATE. When I try to use it in
> the following pl/pgSQL function it gives the error:
> BEGIN
> curtime := 'CURRENT_DA
I am trying to write a function that updates the
date column to the current date. According to:
http://www.postgresql.org/docs/8.4/static/functions-datetime.html#FUNCTIONS-DATETIME-CURRENT
you can use CURRENT_DATE. When I try to use it in
the following pl/pgSQL function it gives the error:
ERROR
11 matches
Mail list logo
