Re: \dv and other lists SQL are unnecessarily complicated

On Thu, Apr 18, 2002 at 11:44:42PM +0100, Bug Finder wrote:
> Hello
>
> Please forgive me if this has been discussed before.
>
> \dv and other lists SQL are unnecessarily complicated.
>
> They all seem to be based on the \d SQL
>
> \dv currently uses

[snip]

IIRC (you should check the source), instead of having one query for each
type of \d command, there is the one query you gave with the 'c.relkind IN'
parameterised.

Yes, it makes the queries more complicated than might otherwise be
necessary, but it cleans up the source code enourmously.

> Is there a reason for this? Was it a cut'n'paste frenzy? not that there
> is anything wrong with that - whatever gets it done.

That's the point, doing it this way avoid doing any cutting and pasting at
all.

HTH,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Ignorance continues to thrive when intelligent people choose to do
> nothing. Speaking out against censorship and ignorance is the imperative
> of all intelligent people.