Re: hint unique result from union

From: Matteo Bertini <matteo(at)naufraghi(dot)net>
To: pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: Re: hint unique result from union
Date: 2006-08-16 20:26:10
Message-ID: 44E37F62.8000608@naufraghi.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Correct! Didn't noticed the "never executed" in the explain analyze
output :-P

Steve Atkins ha scritto:
>
>
> "select foo from bar limit 1" ?
>
> I don't know if there's any guaranteed ordering of results from
> a union query, though, and that's what a query on a set of
> inherited tables will expand to, pretty much.
>
> Cheers,
> Steve
>

Attachment Content-Type Size
matteo.vcf text/x-vcard 354 bytes

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Murphy 2006-08-16 20:32:34 Re: COLLATE
Previous Message Tom Lane 2006-08-16 20:21:19 Re: Segmentation Fault