On Thu, Dec 17, 2009 at 10:24:28AM -0500, Tom Lane wrote: > Justin Bailey <jgbailey@xxxxxxxxx> writes: > > If s was automatically truncated, the insert would succeed, but it > > fails with a "value too long" error. > > Oh, I thought the failure was the behavior you wanted. There's > no automatic truncation here --- perhaps putting an exception > block around it would be the way to go? I think the OP wants to be able to use the "%TYPE" magic in more places than the grammar currently accepts. For example, so that you can use it in a CAST expression as per some of the examples. Would using DOMAINs be a better alternative? It certainly works now. -- Sam http://samason.me.uk/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
