Re: 8.3 vs 8.2 sql compatiblity issue - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: 8.3 vs 8.2 sql compatiblity issue
Date
Msg-id 20071115215908.GF17793@alvh.no-ip.org
Whole thread Raw
In response to Re: 8.3 vs 8.2 sql compatiblity issue  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Tom thinks it's bad code was 8.3 vs 8.2 sql compatibility issue  (Tony Caduto <tony_caduto@amsoftwaredesign.com>)
List pgsql-general
Tom Lane wrote:
> Tony Caduto <tony_caduto@amsoftwaredesign.com> writes:

> > case when cast(a.attnum as text) IN( select array_to_string(conkey,',')
> > from pg_constraint where
>
> Surely that's the worst bit of SQL code I've seen in awhile.

Wow, you really are lucky.

--
Alvaro Herrera                 http://www.amazon.com/gp/registry/DXLWNGRJD34J
"Java is clearly an example of money oriented programming"  (A. Stepanov)

pgsql-general by date:

Previous
From: Reg Me Please
Date:
Subject: Re: Variable LIMIT and OFFSET in SELECTs
Next
From: Richard Huxton
Date:
Subject: Re: Variable LIMIT and OFFSET in SELECTs