Re: Problems with PLPGSQL - Mailing list pgsql-general

From Richard Huxton
Subject Re: Problems with PLPGSQL
Date
Msg-id 200311060913.07354.dev@archonet.com
Whole thread Raw
In response to Problems with PLPGSQL  (Alex <alex@meerkatsoft.com>)
Responses Re: Problems with PLPGSQL  (Alex <alex@meerkatsoft.com>)
List pgsql-general
On Thursday 06 November 2003 04:13, Alex wrote:
> Hi,
> I have a problem with quoting  in one of my functions:
>
> now TIMESTAMP := ''now'';

Your main question has been answered, but you might want now() rather than
''now''. Off the top of my head, I think the ''now'' might get compiled as a
value on the first run and stay at that value.

--
  Richard Huxton
  Archonet Ltd

pgsql-general by date:

Previous
From: Csaba Nagy
Date:
Subject: Re: Sequences without blank holes
Next
From: Alex
Date:
Subject: Re: Problems with PLPGSQL