Re: Re: [pgsql-es-ayuda] Ordenar la cosnulta segun orden de creación de campos o (OID de campo) y devolver schemma de un FK determinado (pongo sql deejemplo)

On Nov 13, 2007 11:02 PM, Yoel Mc Lennan <listas(at)yoel(dot)com(dot)ar> wrote:
> algo no funciono en nspname, alguna idea?
>
> > SELECT n.nspname, conname,pg_catalog.pg_get_constraintdef(oid) as
> > condef FROM
> > pg_catalog.pg_constraint r WHERE r.conrelid = (SELECT c.oid
> > FROM pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_namespace n
> > ON n.oid = c.relnamespace WHERE c.relname ='mitabla' AND
> > n.nspname ='public')
> > AND r.contype = 'f';
>
> n.nspname, conname, ...
>

eso es porque en el select principal no existe ninguna relacion n, esa
existe solo para el select mas interno... yo intentaria reescribir eso
como un JOIN

--
Atentamente,
Jaime Casanova

"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
Richard Cook