Re: pg_get_viewdef 7.4 et al

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andreas Pflug <Andreas(dot)Pflug(at)web(dot)de>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: pg_get_viewdef 7.4 et al
Date: 2003-04-09 14:20:25
Message-ID: 6743.1049898025@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers pgsql-hackers

Andreas Pflug <Andreas(dot)Pflug(at)web(dot)de> writes:
> it was a cvs diff, should I upload the whole source?

diff -c is the standard format for patch submissions.

Some people use diff -u, but I find that less readable.

> I wasn't able to force a T_CoerceToDomain, and only got T_RelabelType
> with simple variables.

Try (foo || bar)::varchar to see an example of a relabel on a nontrivial
input expression. For CoerceToDomain, try creating a domain over text
and then coerce to that.

regards, tom lane

In response to

Browse pgadmin-hackers by date

  From Date Subject
Next Message Dave Page 2003-04-09 14:33:40 CVS Server
Previous Message Andreas Pflug 2003-04-09 10:57:36 Re: [HACKERS] pg_get_viewdef 7.4 et al

Browse pgsql-hackers by date

  From Date Subject
Next Message Stephan Szabo 2003-04-09 14:48:53 Question about simple function folding optimization
Previous Message Jan Wieck 2003-04-09 14:13:45 Re: Anyone know why PostgreSQL doesn't support 2 phase