Question on utility statements and parameterization

From: Chris Travers <chris(dot)travers(at)gmail(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Question on utility statements and parameterization
Date: 2011-07-19 21:34:30
Message-ID: CAKt_ZfvGcw3NG49bAnoy9nxO=XvvC9cwNeXUPmaYDuH8wkEN-Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all;

As I understand, utility statements are not generally parameterized, so:

postgres=# alter user test123 with password 'foo' valid until now() +
'1 day'::interval;
ERROR: syntax error at or near "now"
LINE 1: ...lter user test123 with password 'foo' valid until now() + '1...

Is this by design? If so, what is the reason? If not, what would
have to be done to change this?

Best Wishes,
Chris Travers

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2011-07-19 21:40:03 Re: Question on utility statements and parameterization
Previous Message Antonio Vieiro 2011-07-19 21:32:46 Re: Detecting memory leaks with libpq?