Re: pg_get_viewdef 7.4 et al - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_get_viewdef 7.4 et al
Date
Msg-id 6743.1049898025@sss.pgh.pa.us
Whole thread Raw
In response to pg_get_viewdef 7.4 et al  (Andreas Pflug <Andreas.Pflug@web.de>)
List pgsql-hackers
Andreas Pflug <Andreas.Pflug@web.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



pgsql-hackers by date:

Previous
From: Jan Wieck
Date:
Subject: Re: Anyone know why PostgreSQL doesn't support 2 phase
Next
From: Stephan Szabo
Date:
Subject: Question about simple function folding optimization