Re: [GENERAL] inherited type

2005-04-01 Thread Michael Fuhr
On Fri, Apr 01, 2005 at 12:42:19PM +0200, Miguel Angel Tribaldos Hervas wrote: > > I am working with inheritance in postgresql 7.4. If I create a table named A, > and another named B that inherits from A, if I perform a query such a > "SELECT * FROM A" (without ONLY clause), > how can I get the ty

Re: [GENERAL] inherited type

2005-04-01 Thread Tom Lane
Miguel Angel Tribaldos Hervas <[EMAIL PROTECTED]> writes: > I am working with inheritance in postgresql 7.4. If I create a table named A, > and another named B that inherits from A, if I perform a query such a > "SELECT * FROM A" (without ONLY clause), > how can I get the type (identifier from pg_t

[GENERAL] inherited type

2005-04-01 Thread Miguel Angel Tribaldos Hervas
Hi, I am working with inheritance in postgresql 7.4. If I create a table named A, and another named B that inherits from A, if I perform a query such a "SELECT * FROM A" (without ONLY clause), how can I get the type (identifier from pg_type) of the returned records?? Thanks in advance. -- --