Re: [GENERAL] getting domain information from query results

2014-01-09 Thread Tom Lane
Marco Baringer writes: > it seems, if my understanding of the protocol is correct, that the oid > of the underlying type, text in this case, is returned and not the oid > of the domain. That's correct. This was an intentional decision long ago, and we're unlikely to reconsider now for fear of br

Re: [GENERAL] getting domain information from query results

2014-01-09 Thread Karsten Hilbert
On Thu, Jan 09, 2014 at 12:10:34PM +0100, Marco Baringer wrote: > assuming i have this schema: > > create domain almost_a_string AS text; > create table object ( name_like_thing almost_a_string ); > > and i'm trying to go from the results, using postgresql's > frontend/backend protocol, of t