Re: Allow COMMENT ON to accept an expression rather than just a string

Jaime Casanova wrote:
> On Fri, Apr 10, 2009 at 11:47 PM, Abhijit Menon-Sen <ams(at)oryx(dot)com> wrote:
> > Hi.
> >
> > There's a TODO item about making COMMENT ON accept an expression.
>
> really? what's the use case for that?

I assume it is for creating comments using things like || or maybe
CURRENT_TIMESTAMP:

test=> CREATE TABLE test (x INT);
CREATE TABLE
test=> COMMENT ON TABLE test IS 'asdf';
COMMENT
test=> COMMENT ON TABLE test IS 'asdf' || 'bb';
ERROR: syntax error at or near "||"
LINE 1: COMMENT ON TABLE test IS 'asdf' || 'bb';

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +