Re: BUG #4693: When I use the order by it gets me an error, but if i use it without order by it's a correct query. - Mailing list pgsql-bugs

On Wed, Mar 4, 2009 at 2:05 PM, Oscar Bejarano <obejaranoc@msn.com> wrote:
>
> The following bug has been logged online:
>
> Bug reference: =A0 =A0 =A04693
> Logged by: =A0 =A0 =A0 =A0 =A0Oscar Bejarano
> Email address: =A0 =A0 =A0obejaranoc@msn.com
> PostgreSQL version: 8.3.0
> Operating system: =A0 Suse 10
> Description: =A0 =A0 =A0 =A0When I use the order by it gets me an error, =
but if i
> use it without order by it's a correct query.
> Details:
>
> =3D=3D=3D=3D=3D=3D=3DQUERY=3D=3D=3D=3D=3D=3D=3D=3D=3D

which ORDER BY is causing troubles to you? the one in ther outer query
or the one in the inner query?
can you provide at least the error message? a little test case would be use=
ful

--=20
Atentamente,
Jaime Casanova
Soporte y capacitaci=F3n de PostgreSQL
Asesor=EDa y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157