Re: Problems with PLPGSQL

From: Richard Huxton <dev(at)archonet(dot)com>
To: Alex <alex(at)meerkatsoft(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Problems with PLPGSQL
Date: 2003-11-06 09:13:07
Message-ID: 200311060913.07354.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alex 2003-11-06 09:17:52 Re: Problems with PLPGSQL
Previous Message Csaba Nagy 2003-11-06 09:12:33 Re: Sequences without blank holes