Re: Allow COMMENT ON to accept an expression rather than just a string - Mailing list pgsql-hackers

Jaime Casanova wrote:
> On Fri, Apr 10, 2009 at 11:47 PM, Abhijit Menon-Sen <ams@oryx.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 TABLEtest=> COMMENT ON TABLE test IS 'asdf';COMMENTtest=> 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@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +