Re: pg_casts view (was Re: date_trun() with timezones? (was Re: TIME column ...))

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Bill Moran <wmoran(at)collaborativefusion(dot)com>, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: pg_casts view (was Re: date_trun() with timezones? (was Re: TIME column ...))
Date: 2008-11-05 17:44:08
Message-ID: 29938.1225907048@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> Tom Lane wrote:
>> Maybe we should just agree that its argument is a pattern for the
>> castsource type's name?

> I'd say it could be a pattern for both source and target. Often times I
> am interested in casts in either direction.

Well, it makes the query markedly uglier, but I suppose we aren't too
concerned about the performance of \dC. New proposed patch attached.

regards, tom lane

Attachment Content-Type Size
unknown_filename text/plain 5.5 KB

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Brandon Metcalf 2008-11-05 17:49:20 storing passwords
Previous Message Robert Fitzpatrick 2008-11-05 17:18:41 worker took too long to start; cancelled